﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Data;
using System.Data.SqlClient;

namespace BaoShouTangServer.ApiModels
{
    public class zpurpoheader
    {
        public zpurpoheader()
        { }
        #region Model
        private int _ivtid;
        private string _ufts;
        private int _poid;
        private string _cchanger;
        private string _cbustype;
        private string _cpoid;
        private DateTime _dpodate;
        private string _cvencode;
        private string _cdepcode;
        private string _cpersoncode;
        private string _carrivalplace;
        private string _csccode;
        private decimal? _nflat;
        private decimal? _itaxrate;
        private string _cpaycode;
        private decimal? _icost;
        private decimal? _ibargain;
        private string _cmemo;
        private int? _cstate;
        private int? _idiscounttaxtype;
        private string _cdefine1;
        private string _cdefine2;
        private string _cdefine3;
        private string _cvenabbname;
        private string _cdepname;
        private string _cpayname;
        private string _cpersonname;
        private string _cexch_name;
        private string _cptcode;
        private string _cperiod;
        private string _cmaker;
        private int _ireturncount;
        private int _iverifystateex;
        private bool _iswfcontrolled;
        private string _cverifier;
        private string _cvenname;
        private string _ccloser;
        private string _cptname;
        private string _cscname;
        private DateTime? _cdefine4;
        private int? _cdefine5;
        private DateTime? _cdefine6;
        private decimal? _cdefine7;
        private string _cdefine8;
        private string _cdefine9;
        private string _cvenaddress;
        private string _cvenpostcode;
        private string _cvenregcode;
        private string _cvoucherstate;
        private int? _dplanarrdate;
        private string _cvenbank;
        private string _cvenaccount;
        private string _cvenfax;
        private string _ccontactcode;
        private string _cvenperson;
        private string _cappcode;
        private string _cvenphone;
        private string _cmobilephone;
        private string _cdefine10;
        private string _cdefine11;
        private string _cdefine12;
        private string _cdefine13;
        private string _cdefine14;
        private int? _cdefine15;
        private decimal? _cdefine16;
        private int? _cauthid;
        private string _cvendefine1;
        private string _cvendefine2;
        private string _cvendefine3;
        private string _cvendefine4;
        private string _cvendefine5;
        private string _cvendefine6;
        private string _cvendefine7;
        private string _cvendefine8;
        private string _cvendefine9;
        private string _cvendefine10;
        private int? _cvendefine11;
        private int? _cvendefine12;
        private decimal? _cvendefine13;
        private decimal? _cvendefine14;
        private DateTime? _cvendefine15;
        private DateTime? _cvendefine16;
        private string _clocker;
        private DateTime? _cmaketime;
        private DateTime? _cmodifytime;
        private DateTime? _caudittime;
        private DateTime? _cmodifydate;
        private DateTime? _cauditdate;
        private string _creviser;
        private string _cvenpuomprotocol;
        private string _cvenpuomprotocolname;
        private string _cchangverifier;
        private DateTime? _cchangaudittime;
        private DateTime? _cchangauditdate;
        private string _cbg_auditor;
        private string _cbg_audittime;
        private int? _controlresult;
        private int? _ibg_overflag;
        private int? _iflowid;
        private string _cflowname;
        private bool _bflowprocess;
        private bool _bstorageorder;
        private int _iprintcount;
        private DateTime? _dclosedate;
        private DateTime? _dclosetime;
        private string _csysbarcode;
        private string _ccurrentauditor;
        private string _cgcroutecode;
        private string _cgcroutename;
        private bool _bgctransforming;
        private string _yyc_respstatus;
        private string _yyc_reason;
        private string _csyssource;
        private string _csyssourceid;
        private string _clshwhcode;
        private string _clshwhname;
        private string _clshwhphone;
        private string _clshwhwhadress;
        /// <summary>
        /// 
        /// </summary>
        public int ivtid
        {
            set { _ivtid = value; }
            get { return _ivtid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ufts
        {
            set { _ufts = value; }
            get { return _ufts; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int poid
        {
            set { _poid = value; }
            get { return _poid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cchanger
        {
            set { _cchanger = value; }
            get { return _cchanger; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbustype
        {
            set { _cbustype = value; }
            get { return _cbustype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpoid
        {
            set { _cpoid = value; }
            get { return _cpoid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime dpodate
        {
            set { _dpodate = value; }
            get { return _dpodate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvencode
        {
            set { _cvencode = value; }
            get { return _cvencode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdepcode
        {
            set { _cdepcode = value; }
            get { return _cdepcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpersoncode
        {
            set { _cpersoncode = value; }
            get { return _cpersoncode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string carrivalplace
        {
            set { _carrivalplace = value; }
            get { return _carrivalplace; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csccode
        {
            set { _csccode = value; }
            get { return _csccode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? nflat
        {
            set { _nflat = value; }
            get { return _nflat; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? itaxrate
        {
            set { _itaxrate = value; }
            get { return _itaxrate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpaycode
        {
            set { _cpaycode = value; }
            get { return _cpaycode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? icost
        {
            set { _icost = value; }
            get { return _icost; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? ibargain
        {
            set { _ibargain = value; }
            get { return _ibargain; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmemo
        {
            set { _cmemo = value; }
            get { return _cmemo; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cstate
        {
            set { _cstate = value; }
            get { return _cstate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? idiscounttaxtype
        {
            set { _idiscounttaxtype = value; }
            get { return _idiscounttaxtype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine1
        {
            set { _cdefine1 = value; }
            get { return _cdefine1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine2
        {
            set { _cdefine2 = value; }
            get { return _cdefine2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine3
        {
            set { _cdefine3 = value; }
            get { return _cdefine3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenabbname
        {
            set { _cvenabbname = value; }
            get { return _cvenabbname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdepname
        {
            set { _cdepname = value; }
            get { return _cdepname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpayname
        {
            set { _cpayname = value; }
            get { return _cpayname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpersonname
        {
            set { _cpersonname = value; }
            get { return _cpersonname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cexch_name
        {
            set { _cexch_name = value; }
            get { return _cexch_name; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cptcode
        {
            set { _cptcode = value; }
            get { return _cptcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cperiod
        {
            set { _cperiod = value; }
            get { return _cperiod; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmaker
        {
            set { _cmaker = value; }
            get { return _cmaker; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int ireturncount
        {
            set { _ireturncount = value; }
            get { return _ireturncount; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int iverifystateex
        {
            set { _iverifystateex = value; }
            get { return _iverifystateex; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool iswfcontrolled
        {
            set { _iswfcontrolled = value; }
            get { return _iswfcontrolled; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cverifier
        {
            set { _cverifier = value; }
            get { return _cverifier; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenname
        {
            set { _cvenname = value; }
            get { return _cvenname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ccloser
        {
            set { _ccloser = value; }
            get { return _ccloser; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cptname
        {
            set { _cptname = value; }
            get { return _cptname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cscname
        {
            set { _cscname = value; }
            get { return _cscname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cdefine4
        {
            set { _cdefine4 = value; }
            get { return _cdefine4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cdefine5
        {
            set { _cdefine5 = value; }
            get { return _cdefine5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cdefine6
        {
            set { _cdefine6 = value; }
            get { return _cdefine6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cdefine7
        {
            set { _cdefine7 = value; }
            get { return _cdefine7; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine8
        {
            set { _cdefine8 = value; }
            get { return _cdefine8; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine9
        {
            set { _cdefine9 = value; }
            get { return _cdefine9; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenaddress
        {
            set { _cvenaddress = value; }
            get { return _cvenaddress; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenpostcode
        {
            set { _cvenpostcode = value; }
            get { return _cvenpostcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenregcode
        {
            set { _cvenregcode = value; }
            get { return _cvenregcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvoucherstate
        {
            set { _cvoucherstate = value; }
            get { return _cvoucherstate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? dplanarrdate
        {
            set { _dplanarrdate = value; }
            get { return _dplanarrdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenbank
        {
            set { _cvenbank = value; }
            get { return _cvenbank; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenaccount
        {
            set { _cvenaccount = value; }
            get { return _cvenaccount; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenfax
        {
            set { _cvenfax = value; }
            get { return _cvenfax; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ccontactcode
        {
            set { _ccontactcode = value; }
            get { return _ccontactcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenperson
        {
            set { _cvenperson = value; }
            get { return _cvenperson; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cappcode
        {
            set { _cappcode = value; }
            get { return _cappcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenphone
        {
            set { _cvenphone = value; }
            get { return _cvenphone; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmobilephone
        {
            set { _cmobilephone = value; }
            get { return _cmobilephone; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine10
        {
            set { _cdefine10 = value; }
            get { return _cdefine10; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine11
        {
            set { _cdefine11 = value; }
            get { return _cdefine11; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine12
        {
            set { _cdefine12 = value; }
            get { return _cdefine12; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine13
        {
            set { _cdefine13 = value; }
            get { return _cdefine13; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine14
        {
            set { _cdefine14 = value; }
            get { return _cdefine14; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cdefine15
        {
            set { _cdefine15 = value; }
            get { return _cdefine15; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cdefine16
        {
            set { _cdefine16 = value; }
            get { return _cdefine16; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cauthid
        {
            set { _cauthid = value; }
            get { return _cauthid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine1
        {
            set { _cvendefine1 = value; }
            get { return _cvendefine1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine2
        {
            set { _cvendefine2 = value; }
            get { return _cvendefine2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine3
        {
            set { _cvendefine3 = value; }
            get { return _cvendefine3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine4
        {
            set { _cvendefine4 = value; }
            get { return _cvendefine4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine5
        {
            set { _cvendefine5 = value; }
            get { return _cvendefine5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine6
        {
            set { _cvendefine6 = value; }
            get { return _cvendefine6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine7
        {
            set { _cvendefine7 = value; }
            get { return _cvendefine7; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine8
        {
            set { _cvendefine8 = value; }
            get { return _cvendefine8; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine9
        {
            set { _cvendefine9 = value; }
            get { return _cvendefine9; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvendefine10
        {
            set { _cvendefine10 = value; }
            get { return _cvendefine10; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cvendefine11
        {
            set { _cvendefine11 = value; }
            get { return _cvendefine11; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cvendefine12
        {
            set { _cvendefine12 = value; }
            get { return _cvendefine12; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cvendefine13
        {
            set { _cvendefine13 = value; }
            get { return _cvendefine13; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cvendefine14
        {
            set { _cvendefine14 = value; }
            get { return _cvendefine14; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cvendefine15
        {
            set { _cvendefine15 = value; }
            get { return _cvendefine15; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cvendefine16
        {
            set { _cvendefine16 = value; }
            get { return _cvendefine16; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string clocker
        {
            set { _clocker = value; }
            get { return _clocker; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cmaketime
        {
            set { _cmaketime = value; }
            get { return _cmaketime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cmodifytime
        {
            set { _cmodifytime = value; }
            get { return _cmodifytime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? caudittime
        {
            set { _caudittime = value; }
            get { return _caudittime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cmodifydate
        {
            set { _cmodifydate = value; }
            get { return _cmodifydate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cauditdate
        {
            set { _cauditdate = value; }
            get { return _cauditdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string creviser
        {
            set { _creviser = value; }
            get { return _creviser; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenpuomprotocol
        {
            set { _cvenpuomprotocol = value; }
            get { return _cvenpuomprotocol; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenpuomprotocolname
        {
            set { _cvenpuomprotocolname = value; }
            get { return _cvenpuomprotocolname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cchangverifier
        {
            set { _cchangverifier = value; }
            get { return _cchangverifier; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cchangaudittime
        {
            set { _cchangaudittime = value; }
            get { return _cchangaudittime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cchangauditdate
        {
            set { _cchangauditdate = value; }
            get { return _cchangauditdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbg_auditor
        {
            set { _cbg_auditor = value; }
            get { return _cbg_auditor; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbg_audittime
        {
            set { _cbg_audittime = value; }
            get { return _cbg_audittime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? controlresult
        {
            set { _controlresult = value; }
            get { return _controlresult; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? ibg_overflag
        {
            set { _ibg_overflag = value; }
            get { return _ibg_overflag; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iflowid
        {
            set { _iflowid = value; }
            get { return _iflowid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cflowname
        {
            set { _cflowname = value; }
            get { return _cflowname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bflowprocess
        {
            set { _bflowprocess = value; }
            get { return _bflowprocess; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bstorageorder
        {
            set { _bstorageorder = value; }
            get { return _bstorageorder; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int iprintcount
        {
            set { _iprintcount = value; }
            get { return _iprintcount; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dclosedate
        {
            set { _dclosedate = value; }
            get { return _dclosedate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dclosetime
        {
            set { _dclosetime = value; }
            get { return _dclosetime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csysbarcode
        {
            set { _csysbarcode = value; }
            get { return _csysbarcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ccurrentauditor
        {
            set { _ccurrentauditor = value; }
            get { return _ccurrentauditor; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cgcroutecode
        {
            set { _cgcroutecode = value; }
            get { return _cgcroutecode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cgcroutename
        {
            set { _cgcroutename = value; }
            get { return _cgcroutename; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bGCTransforming
        {
            set { _bgctransforming = value; }
            get { return _bgctransforming; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string yyc_respstatus
        {
            set { _yyc_respstatus = value; }
            get { return _yyc_respstatus; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string yyc_reason
        {
            set { _yyc_reason = value; }
            get { return _yyc_reason; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csyssource
        {
            set { _csyssource = value; }
            get { return _csyssource; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csyssourceid
        {
            set { _csyssourceid = value; }
            get { return _csyssourceid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string clshwhcode
        {
            set { _clshwhcode = value; }
            get { return _clshwhcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string clshwhname
        {
            set { _clshwhname = value; }
            get { return _clshwhname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string clshwhphone
        {
            set { _clshwhphone = value; }
            get { return _clshwhphone; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string clshwhwhadress
        {
            set { _clshwhwhadress = value; }
            get { return _clshwhwhadress; }
        }
        #endregion Model


        #region  Method

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public zpurpoheader(int ivtid, string ufts, int poid, string cchanger, string cbustype, string cpoid, DateTime dpodate, string cvencode, string cdepcode, string cpersoncode, string carrivalplace, string csccode, decimal nflat, decimal itaxrate, string cpaycode, decimal icost, decimal ibargain, string cmemo, int cstate, int idiscounttaxtype, string cdefine1, string cdefine2, string cdefine3, string cvenabbname, string cdepname, string cpayname, string cpersonname, string cexch_name, string cptcode, string cperiod, string cmaker, int ireturncount, int iverifystateex, bool iswfcontrolled, string cverifier, string cvenname, string ccloser, string cptname, string cscname, DateTime cdefine4, int cdefine5, DateTime cdefine6, decimal cdefine7, string cdefine8, string cdefine9, string cvenaddress, string cvenpostcode, string cvenregcode, string cvoucherstate, int dplanarrdate, string cvenbank, string cvenaccount, string cvenfax, string ccontactcode, string cvenperson, string cappcode, string cvenphone, string cmobilephone, string cdefine10, string cdefine11, string cdefine12, string cdefine13, string cdefine14, int cdefine15, decimal cdefine16, int cauthid, string cvendefine1, string cvendefine2, string cvendefine3, string cvendefine4, string cvendefine5, string cvendefine6, string cvendefine7, string cvendefine8, string cvendefine9, string cvendefine10, int cvendefine11, int cvendefine12, decimal cvendefine13, decimal cvendefine14, DateTime cvendefine15, DateTime cvendefine16, string clocker, DateTime cmaketime, DateTime cmodifytime, DateTime caudittime, DateTime cmodifydate, DateTime cauditdate, string creviser, string cvenpuomprotocol, string cvenpuomprotocolname, string cchangverifier, DateTime cchangaudittime, DateTime cchangauditdate, string cbg_auditor, string cbg_audittime, int controlresult, int ibg_overflag, int iflowid, string cflowname, bool bflowprocess, bool bstorageorder, int iprintcount, DateTime dclosedate, DateTime dclosetime, string csysbarcode, string ccurrentauditor, string cgcroutecode, string cgcroutename, bool bGCTransforming, string yyc_respstatus, string yyc_reason, string csyssource, string csyssourceid, string clshwhcode, string clshwhname, string clshwhphone, string clshwhwhadress)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ivtid,ufts,poid,cchanger,cbustype,cpoid,dpodate,cvencode,cdepcode,cpersoncode,carrivalplace,csccode,nflat,itaxrate,cpaycode,icost,ibargain,cmemo,cstate,idiscounttaxtype,cdefine1,cdefine2,cdefine3,cvenabbname,cdepname,cpayname,cpersonname,cexch_name,cptcode,cperiod,cmaker,ireturncount,iverifystateex,iswfcontrolled,cverifier,cvenname,ccloser,cptname,cscname,cdefine4,cdefine5,cdefine6,cdefine7,cdefine8,cdefine9,cvenaddress,cvenpostcode,cvenregcode,cvoucherstate,dplanarrdate,cvenbank,cvenaccount,cvenfax,ccontactcode,cvenperson,cappcode,cvenphone,cmobilephone,cdefine10,cdefine11,cdefine12,cdefine13,cdefine14,cdefine15,cdefine16,cauthid,cvendefine1,cvendefine2,cvendefine3,cvendefine4,cvendefine5,cvendefine6,cvendefine7,cvendefine8,cvendefine9,cvendefine10,cvendefine11,cvendefine12,cvendefine13,cvendefine14,cvendefine15,cvendefine16,clocker,cmaketime,cmodifytime,caudittime,cmodifydate,cauditdate,creviser,cvenpuomprotocol,cvenpuomprotocolname,cchangverifier,cchangaudittime,cchangauditdate,cbg_auditor,cbg_audittime,controlresult,ibg_overflag,iflowid,cflowname,bflowprocess,bstorageorder,iprintcount,dclosedate,dclosetime,csysbarcode,ccurrentauditor,cgcroutecode,cgcroutename,bGCTransforming,yyc_respstatus,yyc_reason,csyssource,csyssourceid,clshwhcode,clshwhname,clshwhphone,clshwhwhadress ");
            strSql.Append(" FROM [zpurpoheader] ");
            strSql.Append(" where ivtid=@ivtid and ufts=@ufts and poid=@poid and cchanger=@cchanger and cbustype=@cbustype and cpoid=@cpoid and dpodate=@dpodate and cvencode=@cvencode and cdepcode=@cdepcode and cpersoncode=@cpersoncode and carrivalplace=@carrivalplace and csccode=@csccode and nflat=@nflat and itaxrate=@itaxrate and cpaycode=@cpaycode and icost=@icost and ibargain=@ibargain and cmemo=@cmemo and cstate=@cstate and idiscounttaxtype=@idiscounttaxtype and cdefine1=@cdefine1 and cdefine2=@cdefine2 and cdefine3=@cdefine3 and cvenabbname=@cvenabbname and cdepname=@cdepname and cpayname=@cpayname and cpersonname=@cpersonname and cexch_name=@cexch_name and cptcode=@cptcode and cperiod=@cperiod and cmaker=@cmaker and ireturncount=@ireturncount and iverifystateex=@iverifystateex and iswfcontrolled=@iswfcontrolled and cverifier=@cverifier and cvenname=@cvenname and ccloser=@ccloser and cptname=@cptname and cscname=@cscname and cdefine4=@cdefine4 and cdefine5=@cdefine5 and cdefine6=@cdefine6 and cdefine7=@cdefine7 and cdefine8=@cdefine8 and cdefine9=@cdefine9 and cvenaddress=@cvenaddress and cvenpostcode=@cvenpostcode and cvenregcode=@cvenregcode and cvoucherstate=@cvoucherstate and dplanarrdate=@dplanarrdate and cvenbank=@cvenbank and cvenaccount=@cvenaccount and cvenfax=@cvenfax and ccontactcode=@ccontactcode and cvenperson=@cvenperson and cappcode=@cappcode and cvenphone=@cvenphone and cmobilephone=@cmobilephone and cdefine10=@cdefine10 and cdefine11=@cdefine11 and cdefine12=@cdefine12 and cdefine13=@cdefine13 and cdefine14=@cdefine14 and cdefine15=@cdefine15 and cdefine16=@cdefine16 and cauthid=@cauthid and cvendefine1=@cvendefine1 and cvendefine2=@cvendefine2 and cvendefine3=@cvendefine3 and cvendefine4=@cvendefine4 and cvendefine5=@cvendefine5 and cvendefine6=@cvendefine6 and cvendefine7=@cvendefine7 and cvendefine8=@cvendefine8 and cvendefine9=@cvendefine9 and cvendefine10=@cvendefine10 and cvendefine11=@cvendefine11 and cvendefine12=@cvendefine12 and cvendefine13=@cvendefine13 and cvendefine14=@cvendefine14 and cvendefine15=@cvendefine15 and cvendefine16=@cvendefine16 and clocker=@clocker and cmaketime=@cmaketime and cmodifytime=@cmodifytime and caudittime=@caudittime and cmodifydate=@cmodifydate and cauditdate=@cauditdate and creviser=@creviser and cvenpuomprotocol=@cvenpuomprotocol and cvenpuomprotocolname=@cvenpuomprotocolname and cchangverifier=@cchangverifier and cchangaudittime=@cchangaudittime and cchangauditdate=@cchangauditdate and cbg_auditor=@cbg_auditor and cbg_audittime=@cbg_audittime and controlresult=@controlresult and ibg_overflag=@ibg_overflag and iflowid=@iflowid and cflowname=@cflowname and bflowprocess=@bflowprocess and bstorageorder=@bstorageorder and iprintcount=@iprintcount and dclosedate=@dclosedate and dclosetime=@dclosetime and csysbarcode=@csysbarcode and ccurrentauditor=@ccurrentauditor and cgcroutecode=@cgcroutecode and cgcroutename=@cgcroutename and bGCTransforming=@bGCTransforming and yyc_respstatus=@yyc_respstatus and yyc_reason=@yyc_reason and csyssource=@csyssource and csyssourceid=@csyssourceid and clshwhcode=@clshwhcode and clshwhname=@clshwhname and clshwhphone=@clshwhphone and clshwhwhadress=@clshwhwhadress ");
            SqlParameter[] parameters = {
                    new SqlParameter("@ivtid", SqlDbType.Int,4),
                    new SqlParameter("@ufts", SqlDbType.Char,10),
                    new SqlParameter("@poid", SqlDbType.Int,4),
                    new SqlParameter("@cchanger", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbustype", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpoid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dpodate", SqlDbType.DateTime),
                    new SqlParameter("@cvencode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersoncode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@carrivalplace", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csccode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@nflat", SqlDbType.Float),
                    new SqlParameter("@itaxrate", SqlDbType.Float),
                    new SqlParameter("@cpaycode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@icost", SqlDbType.Money),
                    new SqlParameter("@ibargain", SqlDbType.Money),
                    new SqlParameter("@cmemo", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cstate", SqlDbType.TinyInt),
                    new SqlParameter("@idiscounttaxtype", SqlDbType.TinyInt),
                    new SqlParameter("@cdefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenabbname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpayname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersonname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cexch_name", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cperiod", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ireturncount", SqlDbType.Int,4),
                    new SqlParameter("@iverifystateex", SqlDbType.Int,4),
                    new SqlParameter("@iswfcontrolled", SqlDbType.Bit,1),
                    new SqlParameter("@cverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccloser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cscname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine4", SqlDbType.DateTime),
                    new SqlParameter("@cdefine5", SqlDbType.Int,4),
                    new SqlParameter("@cdefine6", SqlDbType.DateTime),
                    new SqlParameter("@cdefine7", SqlDbType.Float),
                    new SqlParameter("@cdefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaddress", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpostcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenregcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvoucherstate", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dplanarrdate", SqlDbType.Int,4),
                    new SqlParameter("@cvenbank", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaccount", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenfax", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccontactcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenperson", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cappcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmobilephone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine11", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine12", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine13", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine14", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine15", SqlDbType.Int,4),
                    new SqlParameter("@cdefine16", SqlDbType.Float),
                    new SqlParameter("@cauthid", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine4", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine5", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine6", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine7", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine11", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine12", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine13", SqlDbType.Float),
                    new SqlParameter("@cvendefine14", SqlDbType.Float),
                    new SqlParameter("@cvendefine15", SqlDbType.DateTime),
                    new SqlParameter("@cvendefine16", SqlDbType.DateTime),
                    new SqlParameter("@clocker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaketime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifytime", SqlDbType.DateTime),
                    new SqlParameter("@caudittime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifydate", SqlDbType.DateTime),
                    new SqlParameter("@cauditdate", SqlDbType.DateTime),
                    new SqlParameter("@creviser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocol", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocolname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangaudittime", SqlDbType.DateTime),
                    new SqlParameter("@cchangauditdate", SqlDbType.DateTime),
                    new SqlParameter("@cbg_auditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbg_audittime", SqlDbType.NVarChar,-1),
                    new SqlParameter("@controlresult", SqlDbType.SmallInt),
                    new SqlParameter("@ibg_overflag", SqlDbType.SmallInt),
                    new SqlParameter("@iflowid", SqlDbType.Int,4),
                    new SqlParameter("@cflowname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bflowprocess", SqlDbType.Bit,1),
                    new SqlParameter("@bstorageorder", SqlDbType.Bit,1),
                    new SqlParameter("@iprintcount", SqlDbType.Int,4),
                    new SqlParameter("@dclosedate", SqlDbType.DateTime),
                    new SqlParameter("@dclosetime", SqlDbType.DateTime),
                    new SqlParameter("@csysbarcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccurrentauditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutecode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutename", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bGCTransforming", SqlDbType.Bit,1),
                    new SqlParameter("@yyc_respstatus", SqlDbType.NVarChar,-1),
                    new SqlParameter("@yyc_reason", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssource", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssourceid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhwhadress", SqlDbType.NVarChar,-1)};
            parameters[0].Value = ivtid;
            parameters[1].Value = ufts;
            parameters[2].Value = poid;
            parameters[3].Value = cchanger;
            parameters[4].Value = cbustype;
            parameters[5].Value = cpoid;
            parameters[6].Value = dpodate;
            parameters[7].Value = cvencode;
            parameters[8].Value = cdepcode;
            parameters[9].Value = cpersoncode;
            parameters[10].Value = carrivalplace;
            parameters[11].Value = csccode;
            parameters[12].Value = nflat;
            parameters[13].Value = itaxrate;
            parameters[14].Value = cpaycode;
            parameters[15].Value = icost;
            parameters[16].Value = ibargain;
            parameters[17].Value = cmemo;
            parameters[18].Value = cstate;
            parameters[19].Value = idiscounttaxtype;
            parameters[20].Value = cdefine1;
            parameters[21].Value = cdefine2;
            parameters[22].Value = cdefine3;
            parameters[23].Value = cvenabbname;
            parameters[24].Value = cdepname;
            parameters[25].Value = cpayname;
            parameters[26].Value = cpersonname;
            parameters[27].Value = cexch_name;
            parameters[28].Value = cptcode;
            parameters[29].Value = cperiod;
            parameters[30].Value = cmaker;
            parameters[31].Value = ireturncount;
            parameters[32].Value = iverifystateex;
            parameters[33].Value = iswfcontrolled;
            parameters[34].Value = cverifier;
            parameters[35].Value = cvenname;
            parameters[36].Value = ccloser;
            parameters[37].Value = cptname;
            parameters[38].Value = cscname;
            parameters[39].Value = cdefine4;
            parameters[40].Value = cdefine5;
            parameters[41].Value = cdefine6;
            parameters[42].Value = cdefine7;
            parameters[43].Value = cdefine8;
            parameters[44].Value = cdefine9;
            parameters[45].Value = cvenaddress;
            parameters[46].Value = cvenpostcode;
            parameters[47].Value = cvenregcode;
            parameters[48].Value = cvoucherstate;
            parameters[49].Value = dplanarrdate;
            parameters[50].Value = cvenbank;
            parameters[51].Value = cvenaccount;
            parameters[52].Value = cvenfax;
            parameters[53].Value = ccontactcode;
            parameters[54].Value = cvenperson;
            parameters[55].Value = cappcode;
            parameters[56].Value = cvenphone;
            parameters[57].Value = cmobilephone;
            parameters[58].Value = cdefine10;
            parameters[59].Value = cdefine11;
            parameters[60].Value = cdefine12;
            parameters[61].Value = cdefine13;
            parameters[62].Value = cdefine14;
            parameters[63].Value = cdefine15;
            parameters[64].Value = cdefine16;
            parameters[65].Value = cauthid;
            parameters[66].Value = cvendefine1;
            parameters[67].Value = cvendefine2;
            parameters[68].Value = cvendefine3;
            parameters[69].Value = cvendefine4;
            parameters[70].Value = cvendefine5;
            parameters[71].Value = cvendefine6;
            parameters[72].Value = cvendefine7;
            parameters[73].Value = cvendefine8;
            parameters[74].Value = cvendefine9;
            parameters[75].Value = cvendefine10;
            parameters[76].Value = cvendefine11;
            parameters[77].Value = cvendefine12;
            parameters[78].Value = cvendefine13;
            parameters[79].Value = cvendefine14;
            parameters[80].Value = cvendefine15;
            parameters[81].Value = cvendefine16;
            parameters[82].Value = clocker;
            parameters[83].Value = cmaketime;
            parameters[84].Value = cmodifytime;
            parameters[85].Value = caudittime;
            parameters[86].Value = cmodifydate;
            parameters[87].Value = cauditdate;
            parameters[88].Value = creviser;
            parameters[89].Value = cvenpuomprotocol;
            parameters[90].Value = cvenpuomprotocolname;
            parameters[91].Value = cchangverifier;
            parameters[92].Value = cchangaudittime;
            parameters[93].Value = cchangauditdate;
            parameters[94].Value = cbg_auditor;
            parameters[95].Value = cbg_audittime;
            parameters[96].Value = controlresult;
            parameters[97].Value = ibg_overflag;
            parameters[98].Value = iflowid;
            parameters[99].Value = cflowname;
            parameters[100].Value = bflowprocess;
            parameters[101].Value = bstorageorder;
            parameters[102].Value = iprintcount;
            parameters[103].Value = dclosedate;
            parameters[104].Value = dclosetime;
            parameters[105].Value = csysbarcode;
            parameters[106].Value = ccurrentauditor;
            parameters[107].Value = cgcroutecode;
            parameters[108].Value = cgcroutename;
            parameters[109].Value = bGCTransforming;
            parameters[110].Value = yyc_respstatus;
            parameters[111].Value = yyc_reason;
            parameters[112].Value = csyssource;
            parameters[113].Value = csyssourceid;
            parameters[114].Value = clshwhcode;
            parameters[115].Value = clshwhname;
            parameters[116].Value = clshwhphone;
            parameters[117].Value = clshwhwhadress;

            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ivtid"] != null && ds.Tables[0].Rows[0]["ivtid"].ToString() != "")
                {
                    this.ivtid = int.Parse(ds.Tables[0].Rows[0]["ivtid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ufts"] != null)
                {
                    this.ufts = ds.Tables[0].Rows[0]["ufts"].ToString();
                }
                if (ds.Tables[0].Rows[0]["poid"] != null && ds.Tables[0].Rows[0]["poid"].ToString() != "")
                {
                    this.poid = int.Parse(ds.Tables[0].Rows[0]["poid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cchanger"] != null)
                {
                    this.cchanger = ds.Tables[0].Rows[0]["cchanger"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cbustype"] != null)
                {
                    this.cbustype = ds.Tables[0].Rows[0]["cbustype"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpoid"] != null)
                {
                    this.cpoid = ds.Tables[0].Rows[0]["cpoid"].ToString();
                }
                if (ds.Tables[0].Rows[0]["dpodate"] != null && ds.Tables[0].Rows[0]["dpodate"].ToString() != "")
                {
                    this.dpodate = DateTime.Parse(ds.Tables[0].Rows[0]["dpodate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvencode"] != null)
                {
                    this.cvencode = ds.Tables[0].Rows[0]["cvencode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdepcode"] != null)
                {
                    this.cdepcode = ds.Tables[0].Rows[0]["cdepcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpersoncode"] != null)
                {
                    this.cpersoncode = ds.Tables[0].Rows[0]["cpersoncode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["carrivalplace"] != null)
                {
                    this.carrivalplace = ds.Tables[0].Rows[0]["carrivalplace"].ToString();
                }
                if (ds.Tables[0].Rows[0]["csccode"] != null)
                {
                    this.csccode = ds.Tables[0].Rows[0]["csccode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["nflat"] != null && ds.Tables[0].Rows[0]["nflat"].ToString() != "")
                {
                    this.nflat = decimal.Parse(ds.Tables[0].Rows[0]["nflat"].ToString());
                }
                if (ds.Tables[0].Rows[0]["itaxrate"] != null && ds.Tables[0].Rows[0]["itaxrate"].ToString() != "")
                {
                    this.itaxrate = decimal.Parse(ds.Tables[0].Rows[0]["itaxrate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cpaycode"] != null)
                {
                    this.cpaycode = ds.Tables[0].Rows[0]["cpaycode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["icost"] != null && ds.Tables[0].Rows[0]["icost"].ToString() != "")
                {
                    this.icost = decimal.Parse(ds.Tables[0].Rows[0]["icost"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ibargain"] != null && ds.Tables[0].Rows[0]["ibargain"].ToString() != "")
                {
                    this.ibargain = decimal.Parse(ds.Tables[0].Rows[0]["ibargain"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cmemo"] != null)
                {
                    this.cmemo = ds.Tables[0].Rows[0]["cmemo"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cstate"] != null && ds.Tables[0].Rows[0]["cstate"].ToString() != "")
                {
                    this.cstate = int.Parse(ds.Tables[0].Rows[0]["cstate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["idiscounttaxtype"] != null && ds.Tables[0].Rows[0]["idiscounttaxtype"].ToString() != "")
                {
                    this.idiscounttaxtype = int.Parse(ds.Tables[0].Rows[0]["idiscounttaxtype"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine1"] != null)
                {
                    this.cdefine1 = ds.Tables[0].Rows[0]["cdefine1"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine2"] != null)
                {
                    this.cdefine2 = ds.Tables[0].Rows[0]["cdefine2"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine3"] != null)
                {
                    this.cdefine3 = ds.Tables[0].Rows[0]["cdefine3"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenabbname"] != null)
                {
                    this.cvenabbname = ds.Tables[0].Rows[0]["cvenabbname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdepname"] != null)
                {
                    this.cdepname = ds.Tables[0].Rows[0]["cdepname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpayname"] != null)
                {
                    this.cpayname = ds.Tables[0].Rows[0]["cpayname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpersonname"] != null)
                {
                    this.cpersonname = ds.Tables[0].Rows[0]["cpersonname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cexch_name"] != null)
                {
                    this.cexch_name = ds.Tables[0].Rows[0]["cexch_name"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cptcode"] != null)
                {
                    this.cptcode = ds.Tables[0].Rows[0]["cptcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cperiod"] != null)
                {
                    this.cperiod = ds.Tables[0].Rows[0]["cperiod"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cmaker"] != null)
                {
                    this.cmaker = ds.Tables[0].Rows[0]["cmaker"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ireturncount"] != null && ds.Tables[0].Rows[0]["ireturncount"].ToString() != "")
                {
                    this.ireturncount = int.Parse(ds.Tables[0].Rows[0]["ireturncount"].ToString());
                }
                if (ds.Tables[0].Rows[0]["iverifystateex"] != null && ds.Tables[0].Rows[0]["iverifystateex"].ToString() != "")
                {
                    this.iverifystateex = int.Parse(ds.Tables[0].Rows[0]["iverifystateex"].ToString());
                }
                if (ds.Tables[0].Rows[0]["iswfcontrolled"] != null && ds.Tables[0].Rows[0]["iswfcontrolled"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["iswfcontrolled"].ToString() == "1") || (ds.Tables[0].Rows[0]["iswfcontrolled"].ToString().ToLower() == "true"))
                    {
                        this.iswfcontrolled = true;
                    }
                    else
                    {
                        this.iswfcontrolled = false;
                    }
                }

                if (ds.Tables[0].Rows[0]["cverifier"] != null)
                {
                    this.cverifier = ds.Tables[0].Rows[0]["cverifier"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenname"] != null)
                {
                    this.cvenname = ds.Tables[0].Rows[0]["cvenname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ccloser"] != null)
                {
                    this.ccloser = ds.Tables[0].Rows[0]["ccloser"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cptname"] != null)
                {
                    this.cptname = ds.Tables[0].Rows[0]["cptname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cscname"] != null)
                {
                    this.cscname = ds.Tables[0].Rows[0]["cscname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine4"] != null && ds.Tables[0].Rows[0]["cdefine4"].ToString() != "")
                {
                    this.cdefine4 = DateTime.Parse(ds.Tables[0].Rows[0]["cdefine4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine5"] != null && ds.Tables[0].Rows[0]["cdefine5"].ToString() != "")
                {
                    this.cdefine5 = int.Parse(ds.Tables[0].Rows[0]["cdefine5"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine6"] != null && ds.Tables[0].Rows[0]["cdefine6"].ToString() != "")
                {
                    this.cdefine6 = DateTime.Parse(ds.Tables[0].Rows[0]["cdefine6"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine7"] != null && ds.Tables[0].Rows[0]["cdefine7"].ToString() != "")
                {
                    this.cdefine7 = decimal.Parse(ds.Tables[0].Rows[0]["cdefine7"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine8"] != null)
                {
                    this.cdefine8 = ds.Tables[0].Rows[0]["cdefine8"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine9"] != null)
                {
                    this.cdefine9 = ds.Tables[0].Rows[0]["cdefine9"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenaddress"] != null)
                {
                    this.cvenaddress = ds.Tables[0].Rows[0]["cvenaddress"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenpostcode"] != null)
                {
                    this.cvenpostcode = ds.Tables[0].Rows[0]["cvenpostcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenregcode"] != null)
                {
                    this.cvenregcode = ds.Tables[0].Rows[0]["cvenregcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvoucherstate"] != null)
                {
                    this.cvoucherstate = ds.Tables[0].Rows[0]["cvoucherstate"].ToString();
                }
                if (ds.Tables[0].Rows[0]["dplanarrdate"] != null && ds.Tables[0].Rows[0]["dplanarrdate"].ToString() != "")
                {
                    this.dplanarrdate = int.Parse(ds.Tables[0].Rows[0]["dplanarrdate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvenbank"] != null)
                {
                    this.cvenbank = ds.Tables[0].Rows[0]["cvenbank"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenaccount"] != null)
                {
                    this.cvenaccount = ds.Tables[0].Rows[0]["cvenaccount"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenfax"] != null)
                {
                    this.cvenfax = ds.Tables[0].Rows[0]["cvenfax"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ccontactcode"] != null)
                {
                    this.ccontactcode = ds.Tables[0].Rows[0]["ccontactcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenperson"] != null)
                {
                    this.cvenperson = ds.Tables[0].Rows[0]["cvenperson"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cappcode"] != null)
                {
                    this.cappcode = ds.Tables[0].Rows[0]["cappcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenphone"] != null)
                {
                    this.cvenphone = ds.Tables[0].Rows[0]["cvenphone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cmobilephone"] != null)
                {
                    this.cmobilephone = ds.Tables[0].Rows[0]["cmobilephone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine10"] != null)
                {
                    this.cdefine10 = ds.Tables[0].Rows[0]["cdefine10"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine11"] != null)
                {
                    this.cdefine11 = ds.Tables[0].Rows[0]["cdefine11"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine12"] != null)
                {
                    this.cdefine12 = ds.Tables[0].Rows[0]["cdefine12"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine13"] != null)
                {
                    this.cdefine13 = ds.Tables[0].Rows[0]["cdefine13"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine14"] != null)
                {
                    this.cdefine14 = ds.Tables[0].Rows[0]["cdefine14"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine15"] != null && ds.Tables[0].Rows[0]["cdefine15"].ToString() != "")
                {
                    this.cdefine15 = int.Parse(ds.Tables[0].Rows[0]["cdefine15"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine16"] != null && ds.Tables[0].Rows[0]["cdefine16"].ToString() != "")
                {
                    this.cdefine16 = decimal.Parse(ds.Tables[0].Rows[0]["cdefine16"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cauthid"] != null && ds.Tables[0].Rows[0]["cauthid"].ToString() != "")
                {
                    this.cauthid = int.Parse(ds.Tables[0].Rows[0]["cauthid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine1"] != null)
                {
                    this.cvendefine1 = ds.Tables[0].Rows[0]["cvendefine1"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine2"] != null)
                {
                    this.cvendefine2 = ds.Tables[0].Rows[0]["cvendefine2"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine3"] != null)
                {
                    this.cvendefine3 = ds.Tables[0].Rows[0]["cvendefine3"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine4"] != null)
                {
                    this.cvendefine4 = ds.Tables[0].Rows[0]["cvendefine4"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine5"] != null)
                {
                    this.cvendefine5 = ds.Tables[0].Rows[0]["cvendefine5"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine6"] != null)
                {
                    this.cvendefine6 = ds.Tables[0].Rows[0]["cvendefine6"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine7"] != null)
                {
                    this.cvendefine7 = ds.Tables[0].Rows[0]["cvendefine7"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine8"] != null)
                {
                    this.cvendefine8 = ds.Tables[0].Rows[0]["cvendefine8"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine9"] != null)
                {
                    this.cvendefine9 = ds.Tables[0].Rows[0]["cvendefine9"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine10"] != null)
                {
                    this.cvendefine10 = ds.Tables[0].Rows[0]["cvendefine10"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine11"] != null && ds.Tables[0].Rows[0]["cvendefine11"].ToString() != "")
                {
                    this.cvendefine11 = int.Parse(ds.Tables[0].Rows[0]["cvendefine11"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine12"] != null && ds.Tables[0].Rows[0]["cvendefine12"].ToString() != "")
                {
                    this.cvendefine12 = int.Parse(ds.Tables[0].Rows[0]["cvendefine12"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine13"] != null && ds.Tables[0].Rows[0]["cvendefine13"].ToString() != "")
                {
                    this.cvendefine13 = decimal.Parse(ds.Tables[0].Rows[0]["cvendefine13"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine14"] != null && ds.Tables[0].Rows[0]["cvendefine14"].ToString() != "")
                {
                    this.cvendefine14 = decimal.Parse(ds.Tables[0].Rows[0]["cvendefine14"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine15"] != null && ds.Tables[0].Rows[0]["cvendefine15"].ToString() != "")
                {
                    this.cvendefine15 = DateTime.Parse(ds.Tables[0].Rows[0]["cvendefine15"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine16"] != null && ds.Tables[0].Rows[0]["cvendefine16"].ToString() != "")
                {
                    this.cvendefine16 = DateTime.Parse(ds.Tables[0].Rows[0]["cvendefine16"].ToString());
                }
                if (ds.Tables[0].Rows[0]["clocker"] != null)
                {
                    this.clocker = ds.Tables[0].Rows[0]["clocker"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cmaketime"] != null && ds.Tables[0].Rows[0]["cmaketime"].ToString() != "")
                {
                    this.cmaketime = DateTime.Parse(ds.Tables[0].Rows[0]["cmaketime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cmodifytime"] != null && ds.Tables[0].Rows[0]["cmodifytime"].ToString() != "")
                {
                    this.cmodifytime = DateTime.Parse(ds.Tables[0].Rows[0]["cmodifytime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["caudittime"] != null && ds.Tables[0].Rows[0]["caudittime"].ToString() != "")
                {
                    this.caudittime = DateTime.Parse(ds.Tables[0].Rows[0]["caudittime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cmodifydate"] != null && ds.Tables[0].Rows[0]["cmodifydate"].ToString() != "")
                {
                    this.cmodifydate = DateTime.Parse(ds.Tables[0].Rows[0]["cmodifydate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cauditdate"] != null && ds.Tables[0].Rows[0]["cauditdate"].ToString() != "")
                {
                    this.cauditdate = DateTime.Parse(ds.Tables[0].Rows[0]["cauditdate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["creviser"] != null)
                {
                    this.creviser = ds.Tables[0].Rows[0]["creviser"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenpuomprotocol"] != null)
                {
                    this.cvenpuomprotocol = ds.Tables[0].Rows[0]["cvenpuomprotocol"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenpuomprotocolname"] != null)
                {
                    this.cvenpuomprotocolname = ds.Tables[0].Rows[0]["cvenpuomprotocolname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cchangverifier"] != null)
                {
                    this.cchangverifier = ds.Tables[0].Rows[0]["cchangverifier"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cchangaudittime"] != null && ds.Tables[0].Rows[0]["cchangaudittime"].ToString() != "")
                {
                    this.cchangaudittime = DateTime.Parse(ds.Tables[0].Rows[0]["cchangaudittime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cchangauditdate"] != null && ds.Tables[0].Rows[0]["cchangauditdate"].ToString() != "")
                {
                    this.cchangauditdate = DateTime.Parse(ds.Tables[0].Rows[0]["cchangauditdate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cbg_auditor"] != null)
                {
                    this.cbg_auditor = ds.Tables[0].Rows[0]["cbg_auditor"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cbg_audittime"] != null)
                {
                    this.cbg_audittime = ds.Tables[0].Rows[0]["cbg_audittime"].ToString();
                }
                if (ds.Tables[0].Rows[0]["controlresult"] != null && ds.Tables[0].Rows[0]["controlresult"].ToString() != "")
                {
                    this.controlresult = int.Parse(ds.Tables[0].Rows[0]["controlresult"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ibg_overflag"] != null && ds.Tables[0].Rows[0]["ibg_overflag"].ToString() != "")
                {
                    this.ibg_overflag = int.Parse(ds.Tables[0].Rows[0]["ibg_overflag"].ToString());
                }
                if (ds.Tables[0].Rows[0]["iflowid"] != null && ds.Tables[0].Rows[0]["iflowid"].ToString() != "")
                {
                    this.iflowid = int.Parse(ds.Tables[0].Rows[0]["iflowid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cflowname"] != null)
                {
                    this.cflowname = ds.Tables[0].Rows[0]["cflowname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["bflowprocess"] != null && ds.Tables[0].Rows[0]["bflowprocess"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["bflowprocess"].ToString() == "1") || (ds.Tables[0].Rows[0]["bflowprocess"].ToString().ToLower() == "true"))
                    {
                        this.bflowprocess = true;
                    }
                    else
                    {
                        this.bflowprocess = false;
                    }
                }

                if (ds.Tables[0].Rows[0]["bstorageorder"] != null && ds.Tables[0].Rows[0]["bstorageorder"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["bstorageorder"].ToString() == "1") || (ds.Tables[0].Rows[0]["bstorageorder"].ToString().ToLower() == "true"))
                    {
                        this.bstorageorder = true;
                    }
                    else
                    {
                        this.bstorageorder = false;
                    }
                }

                if (ds.Tables[0].Rows[0]["iprintcount"] != null && ds.Tables[0].Rows[0]["iprintcount"].ToString() != "")
                {
                    this.iprintcount = int.Parse(ds.Tables[0].Rows[0]["iprintcount"].ToString());
                }
                if (ds.Tables[0].Rows[0]["dclosedate"] != null && ds.Tables[0].Rows[0]["dclosedate"].ToString() != "")
                {
                    this.dclosedate = DateTime.Parse(ds.Tables[0].Rows[0]["dclosedate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["dclosetime"] != null && ds.Tables[0].Rows[0]["dclosetime"].ToString() != "")
                {
                    this.dclosetime = DateTime.Parse(ds.Tables[0].Rows[0]["dclosetime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["csysbarcode"] != null)
                {
                    this.csysbarcode = ds.Tables[0].Rows[0]["csysbarcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ccurrentauditor"] != null)
                {
                    this.ccurrentauditor = ds.Tables[0].Rows[0]["ccurrentauditor"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cgcroutecode"] != null)
                {
                    this.cgcroutecode = ds.Tables[0].Rows[0]["cgcroutecode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cgcroutename"] != null)
                {
                    this.cgcroutename = ds.Tables[0].Rows[0]["cgcroutename"].ToString();
                }
                if (ds.Tables[0].Rows[0]["bGCTransforming"] != null && ds.Tables[0].Rows[0]["bGCTransforming"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["bGCTransforming"].ToString() == "1") || (ds.Tables[0].Rows[0]["bGCTransforming"].ToString().ToLower() == "true"))
                    {
                        this.bGCTransforming = true;
                    }
                    else
                    {
                        this.bGCTransforming = false;
                    }
                }

                if (ds.Tables[0].Rows[0]["yyc_respstatus"] != null)
                {
                    this.yyc_respstatus = ds.Tables[0].Rows[0]["yyc_respstatus"].ToString();
                }
                if (ds.Tables[0].Rows[0]["yyc_reason"] != null)
                {
                    this.yyc_reason = ds.Tables[0].Rows[0]["yyc_reason"].ToString();
                }
                if (ds.Tables[0].Rows[0]["csyssource"] != null)
                {
                    this.csyssource = ds.Tables[0].Rows[0]["csyssource"].ToString();
                }
                if (ds.Tables[0].Rows[0]["csyssourceid"] != null)
                {
                    this.csyssourceid = ds.Tables[0].Rows[0]["csyssourceid"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhcode"] != null)
                {
                    this.clshwhcode = ds.Tables[0].Rows[0]["clshwhcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhname"] != null)
                {
                    this.clshwhname = ds.Tables[0].Rows[0]["clshwhname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhphone"] != null)
                {
                    this.clshwhphone = ds.Tables[0].Rows[0]["clshwhphone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhwhadress"] != null)
                {
                    this.clshwhwhadress = ds.Tables[0].Rows[0]["clshwhwhadress"].ToString();
                }
            }
        }

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int ivtid, string ufts, int poid, string cchanger, string cbustype, string cpoid, DateTime dpodate, string cvencode, string cdepcode, string cpersoncode, string carrivalplace, string csccode, decimal nflat, decimal itaxrate, string cpaycode, decimal icost, decimal ibargain, string cmemo, int cstate, int idiscounttaxtype, string cdefine1, string cdefine2, string cdefine3, string cvenabbname, string cdepname, string cpayname, string cpersonname, string cexch_name, string cptcode, string cperiod, string cmaker, int ireturncount, int iverifystateex, bool iswfcontrolled, string cverifier, string cvenname, string ccloser, string cptname, string cscname, DateTime cdefine4, int cdefine5, DateTime cdefine6, decimal cdefine7, string cdefine8, string cdefine9, string cvenaddress, string cvenpostcode, string cvenregcode, string cvoucherstate, int dplanarrdate, string cvenbank, string cvenaccount, string cvenfax, string ccontactcode, string cvenperson, string cappcode, string cvenphone, string cmobilephone, string cdefine10, string cdefine11, string cdefine12, string cdefine13, string cdefine14, int cdefine15, decimal cdefine16, int cauthid, string cvendefine1, string cvendefine2, string cvendefine3, string cvendefine4, string cvendefine5, string cvendefine6, string cvendefine7, string cvendefine8, string cvendefine9, string cvendefine10, int cvendefine11, int cvendefine12, decimal cvendefine13, decimal cvendefine14, DateTime cvendefine15, DateTime cvendefine16, string clocker, DateTime cmaketime, DateTime cmodifytime, DateTime caudittime, DateTime cmodifydate, DateTime cauditdate, string creviser, string cvenpuomprotocol, string cvenpuomprotocolname, string cchangverifier, DateTime cchangaudittime, DateTime cchangauditdate, string cbg_auditor, string cbg_audittime, int controlresult, int ibg_overflag, int iflowid, string cflowname, bool bflowprocess, bool bstorageorder, int iprintcount, DateTime dclosedate, DateTime dclosetime, string csysbarcode, string ccurrentauditor, string cgcroutecode, string cgcroutename, bool bGCTransforming, string yyc_respstatus, string yyc_reason, string csyssource, string csyssourceid, string clshwhcode, string clshwhname, string clshwhphone, string clshwhwhadress)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from [zpurpoheader]");
            strSql.Append(" where ivtid=@ivtid and ufts=@ufts and poid=@poid and cchanger=@cchanger and cbustype=@cbustype and cpoid=@cpoid and dpodate=@dpodate and cvencode=@cvencode and cdepcode=@cdepcode and cpersoncode=@cpersoncode and carrivalplace=@carrivalplace and csccode=@csccode and nflat=@nflat and itaxrate=@itaxrate and cpaycode=@cpaycode and icost=@icost and ibargain=@ibargain and cmemo=@cmemo and cstate=@cstate and idiscounttaxtype=@idiscounttaxtype and cdefine1=@cdefine1 and cdefine2=@cdefine2 and cdefine3=@cdefine3 and cvenabbname=@cvenabbname and cdepname=@cdepname and cpayname=@cpayname and cpersonname=@cpersonname and cexch_name=@cexch_name and cptcode=@cptcode and cperiod=@cperiod and cmaker=@cmaker and ireturncount=@ireturncount and iverifystateex=@iverifystateex and iswfcontrolled=@iswfcontrolled and cverifier=@cverifier and cvenname=@cvenname and ccloser=@ccloser and cptname=@cptname and cscname=@cscname and cdefine4=@cdefine4 and cdefine5=@cdefine5 and cdefine6=@cdefine6 and cdefine7=@cdefine7 and cdefine8=@cdefine8 and cdefine9=@cdefine9 and cvenaddress=@cvenaddress and cvenpostcode=@cvenpostcode and cvenregcode=@cvenregcode and cvoucherstate=@cvoucherstate and dplanarrdate=@dplanarrdate and cvenbank=@cvenbank and cvenaccount=@cvenaccount and cvenfax=@cvenfax and ccontactcode=@ccontactcode and cvenperson=@cvenperson and cappcode=@cappcode and cvenphone=@cvenphone and cmobilephone=@cmobilephone and cdefine10=@cdefine10 and cdefine11=@cdefine11 and cdefine12=@cdefine12 and cdefine13=@cdefine13 and cdefine14=@cdefine14 and cdefine15=@cdefine15 and cdefine16=@cdefine16 and cauthid=@cauthid and cvendefine1=@cvendefine1 and cvendefine2=@cvendefine2 and cvendefine3=@cvendefine3 and cvendefine4=@cvendefine4 and cvendefine5=@cvendefine5 and cvendefine6=@cvendefine6 and cvendefine7=@cvendefine7 and cvendefine8=@cvendefine8 and cvendefine9=@cvendefine9 and cvendefine10=@cvendefine10 and cvendefine11=@cvendefine11 and cvendefine12=@cvendefine12 and cvendefine13=@cvendefine13 and cvendefine14=@cvendefine14 and cvendefine15=@cvendefine15 and cvendefine16=@cvendefine16 and clocker=@clocker and cmaketime=@cmaketime and cmodifytime=@cmodifytime and caudittime=@caudittime and cmodifydate=@cmodifydate and cauditdate=@cauditdate and creviser=@creviser and cvenpuomprotocol=@cvenpuomprotocol and cvenpuomprotocolname=@cvenpuomprotocolname and cchangverifier=@cchangverifier and cchangaudittime=@cchangaudittime and cchangauditdate=@cchangauditdate and cbg_auditor=@cbg_auditor and cbg_audittime=@cbg_audittime and controlresult=@controlresult and ibg_overflag=@ibg_overflag and iflowid=@iflowid and cflowname=@cflowname and bflowprocess=@bflowprocess and bstorageorder=@bstorageorder and iprintcount=@iprintcount and dclosedate=@dclosedate and dclosetime=@dclosetime and csysbarcode=@csysbarcode and ccurrentauditor=@ccurrentauditor and cgcroutecode=@cgcroutecode and cgcroutename=@cgcroutename and bGCTransforming=@bGCTransforming and yyc_respstatus=@yyc_respstatus and yyc_reason=@yyc_reason and csyssource=@csyssource and csyssourceid=@csyssourceid and clshwhcode=@clshwhcode and clshwhname=@clshwhname and clshwhphone=@clshwhphone and clshwhwhadress=@clshwhwhadress ");

            SqlParameter[] parameters = {
                    new SqlParameter("@ivtid", SqlDbType.Int,4),
                    new SqlParameter("@ufts", SqlDbType.Char,10),
                    new SqlParameter("@poid", SqlDbType.Int,4),
                    new SqlParameter("@cchanger", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbustype", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpoid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dpodate", SqlDbType.DateTime),
                    new SqlParameter("@cvencode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersoncode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@carrivalplace", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csccode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@nflat", SqlDbType.Float),
                    new SqlParameter("@itaxrate", SqlDbType.Float),
                    new SqlParameter("@cpaycode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@icost", SqlDbType.Money),
                    new SqlParameter("@ibargain", SqlDbType.Money),
                    new SqlParameter("@cmemo", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cstate", SqlDbType.TinyInt),
                    new SqlParameter("@idiscounttaxtype", SqlDbType.TinyInt),
                    new SqlParameter("@cdefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenabbname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpayname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersonname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cexch_name", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cperiod", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ireturncount", SqlDbType.Int,4),
                    new SqlParameter("@iverifystateex", SqlDbType.Int,4),
                    new SqlParameter("@iswfcontrolled", SqlDbType.Bit,1),
                    new SqlParameter("@cverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccloser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cscname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine4", SqlDbType.DateTime),
                    new SqlParameter("@cdefine5", SqlDbType.Int,4),
                    new SqlParameter("@cdefine6", SqlDbType.DateTime),
                    new SqlParameter("@cdefine7", SqlDbType.Float),
                    new SqlParameter("@cdefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaddress", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpostcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenregcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvoucherstate", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dplanarrdate", SqlDbType.Int,4),
                    new SqlParameter("@cvenbank", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaccount", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenfax", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccontactcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenperson", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cappcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmobilephone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine11", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine12", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine13", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine14", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine15", SqlDbType.Int,4),
                    new SqlParameter("@cdefine16", SqlDbType.Float),
                    new SqlParameter("@cauthid", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine4", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine5", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine6", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine7", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine11", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine12", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine13", SqlDbType.Float),
                    new SqlParameter("@cvendefine14", SqlDbType.Float),
                    new SqlParameter("@cvendefine15", SqlDbType.DateTime),
                    new SqlParameter("@cvendefine16", SqlDbType.DateTime),
                    new SqlParameter("@clocker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaketime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifytime", SqlDbType.DateTime),
                    new SqlParameter("@caudittime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifydate", SqlDbType.DateTime),
                    new SqlParameter("@cauditdate", SqlDbType.DateTime),
                    new SqlParameter("@creviser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocol", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocolname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangaudittime", SqlDbType.DateTime),
                    new SqlParameter("@cchangauditdate", SqlDbType.DateTime),
                    new SqlParameter("@cbg_auditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbg_audittime", SqlDbType.NVarChar,-1),
                    new SqlParameter("@controlresult", SqlDbType.SmallInt),
                    new SqlParameter("@ibg_overflag", SqlDbType.SmallInt),
                    new SqlParameter("@iflowid", SqlDbType.Int,4),
                    new SqlParameter("@cflowname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bflowprocess", SqlDbType.Bit,1),
                    new SqlParameter("@bstorageorder", SqlDbType.Bit,1),
                    new SqlParameter("@iprintcount", SqlDbType.Int,4),
                    new SqlParameter("@dclosedate", SqlDbType.DateTime),
                    new SqlParameter("@dclosetime", SqlDbType.DateTime),
                    new SqlParameter("@csysbarcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccurrentauditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutecode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutename", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bGCTransforming", SqlDbType.Bit,1),
                    new SqlParameter("@yyc_respstatus", SqlDbType.NVarChar,-1),
                    new SqlParameter("@yyc_reason", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssource", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssourceid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhwhadress", SqlDbType.NVarChar,-1)};
            parameters[0].Value = ivtid;
            parameters[1].Value = ufts;
            parameters[2].Value = poid;
            parameters[3].Value = cchanger;
            parameters[4].Value = cbustype;
            parameters[5].Value = cpoid;
            parameters[6].Value = dpodate;
            parameters[7].Value = cvencode;
            parameters[8].Value = cdepcode;
            parameters[9].Value = cpersoncode;
            parameters[10].Value = carrivalplace;
            parameters[11].Value = csccode;
            parameters[12].Value = nflat;
            parameters[13].Value = itaxrate;
            parameters[14].Value = cpaycode;
            parameters[15].Value = icost;
            parameters[16].Value = ibargain;
            parameters[17].Value = cmemo;
            parameters[18].Value = cstate;
            parameters[19].Value = idiscounttaxtype;
            parameters[20].Value = cdefine1;
            parameters[21].Value = cdefine2;
            parameters[22].Value = cdefine3;
            parameters[23].Value = cvenabbname;
            parameters[24].Value = cdepname;
            parameters[25].Value = cpayname;
            parameters[26].Value = cpersonname;
            parameters[27].Value = cexch_name;
            parameters[28].Value = cptcode;
            parameters[29].Value = cperiod;
            parameters[30].Value = cmaker;
            parameters[31].Value = ireturncount;
            parameters[32].Value = iverifystateex;
            parameters[33].Value = iswfcontrolled;
            parameters[34].Value = cverifier;
            parameters[35].Value = cvenname;
            parameters[36].Value = ccloser;
            parameters[37].Value = cptname;
            parameters[38].Value = cscname;
            parameters[39].Value = cdefine4;
            parameters[40].Value = cdefine5;
            parameters[41].Value = cdefine6;
            parameters[42].Value = cdefine7;
            parameters[43].Value = cdefine8;
            parameters[44].Value = cdefine9;
            parameters[45].Value = cvenaddress;
            parameters[46].Value = cvenpostcode;
            parameters[47].Value = cvenregcode;
            parameters[48].Value = cvoucherstate;
            parameters[49].Value = dplanarrdate;
            parameters[50].Value = cvenbank;
            parameters[51].Value = cvenaccount;
            parameters[52].Value = cvenfax;
            parameters[53].Value = ccontactcode;
            parameters[54].Value = cvenperson;
            parameters[55].Value = cappcode;
            parameters[56].Value = cvenphone;
            parameters[57].Value = cmobilephone;
            parameters[58].Value = cdefine10;
            parameters[59].Value = cdefine11;
            parameters[60].Value = cdefine12;
            parameters[61].Value = cdefine13;
            parameters[62].Value = cdefine14;
            parameters[63].Value = cdefine15;
            parameters[64].Value = cdefine16;
            parameters[65].Value = cauthid;
            parameters[66].Value = cvendefine1;
            parameters[67].Value = cvendefine2;
            parameters[68].Value = cvendefine3;
            parameters[69].Value = cvendefine4;
            parameters[70].Value = cvendefine5;
            parameters[71].Value = cvendefine6;
            parameters[72].Value = cvendefine7;
            parameters[73].Value = cvendefine8;
            parameters[74].Value = cvendefine9;
            parameters[75].Value = cvendefine10;
            parameters[76].Value = cvendefine11;
            parameters[77].Value = cvendefine12;
            parameters[78].Value = cvendefine13;
            parameters[79].Value = cvendefine14;
            parameters[80].Value = cvendefine15;
            parameters[81].Value = cvendefine16;
            parameters[82].Value = clocker;
            parameters[83].Value = cmaketime;
            parameters[84].Value = cmodifytime;
            parameters[85].Value = caudittime;
            parameters[86].Value = cmodifydate;
            parameters[87].Value = cauditdate;
            parameters[88].Value = creviser;
            parameters[89].Value = cvenpuomprotocol;
            parameters[90].Value = cvenpuomprotocolname;
            parameters[91].Value = cchangverifier;
            parameters[92].Value = cchangaudittime;
            parameters[93].Value = cchangauditdate;
            parameters[94].Value = cbg_auditor;
            parameters[95].Value = cbg_audittime;
            parameters[96].Value = controlresult;
            parameters[97].Value = ibg_overflag;
            parameters[98].Value = iflowid;
            parameters[99].Value = cflowname;
            parameters[100].Value = bflowprocess;
            parameters[101].Value = bstorageorder;
            parameters[102].Value = iprintcount;
            parameters[103].Value = dclosedate;
            parameters[104].Value = dclosetime;
            parameters[105].Value = csysbarcode;
            parameters[106].Value = ccurrentauditor;
            parameters[107].Value = cgcroutecode;
            parameters[108].Value = cgcroutename;
            parameters[109].Value = bGCTransforming;
            parameters[110].Value = yyc_respstatus;
            parameters[111].Value = yyc_reason;
            parameters[112].Value = csyssource;
            parameters[113].Value = csyssourceid;
            parameters[114].Value = clshwhcode;
            parameters[115].Value = clshwhname;
            parameters[116].Value = clshwhphone;
            parameters[117].Value = clshwhwhadress;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(string tablename)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into "+  tablename+ " (");
            strSql.Append("ivtid,ufts,poid,cchanger,cbustype,cpoid,dpodate,cvencode,cdepcode,cpersoncode,carrivalplace,csccode,nflat,itaxrate,cpaycode,icost,ibargain,cmemo,cstate,idiscounttaxtype,cdefine1,cdefine2,cdefine3,cvenabbname,cdepname,cpayname,cpersonname,cexch_name,cptcode,cperiod,cmaker,ireturncount,iverifystateex,iswfcontrolled,cverifier,cvenname,ccloser,cptname,cscname,cdefine4,cdefine5,cdefine6,cdefine7,cdefine8,cdefine9,cvenaddress,cvenpostcode,cvenregcode,cvoucherstate,dplanarrdate,cvenbank,cvenaccount,cvenfax,ccontactcode,cvenperson,cappcode,cvenphone,cmobilephone,cdefine10,cdefine11,cdefine12,cdefine13,cdefine14,cdefine15,cdefine16,cauthid,cvendefine1,cvendefine2,cvendefine3,cvendefine4,cvendefine5,cvendefine6,cvendefine7,cvendefine8,cvendefine9,cvendefine10,cvendefine11,cvendefine12,cvendefine13,cvendefine14,cvendefine15,cvendefine16,clocker,cmaketime,cmodifytime,caudittime,cmodifydate,cauditdate,creviser,cvenpuomprotocol,cvenpuomprotocolname,cchangverifier,cchangaudittime,cchangauditdate,cbg_auditor,cbg_audittime,controlresult,ibg_overflag,iflowid,cflowname,bflowprocess,bstorageorder,iprintcount,dclosedate,dclosetime,csysbarcode,ccurrentauditor,cgcroutecode,cgcroutename,bGCTransforming,yyc_respstatus,yyc_reason,csyssource,csyssourceid,clshwhcode,clshwhname,clshwhphone,clshwhwhadress)");
            strSql.Append(" values (");
            strSql.Append("@ivtid,@ufts,@poid,@cchanger,@cbustype,@cpoid,@dpodate,@cvencode,@cdepcode,@cpersoncode,@carrivalplace,@csccode,@nflat,@itaxrate,@cpaycode,@icost,@ibargain,@cmemo,@cstate,@idiscounttaxtype,@cdefine1,@cdefine2,@cdefine3,@cvenabbname,@cdepname,@cpayname,@cpersonname,@cexch_name,@cptcode,@cperiod,@cmaker,@ireturncount,@iverifystateex,@iswfcontrolled,@cverifier,@cvenname,@ccloser,@cptname,@cscname,@cdefine4,@cdefine5,@cdefine6,@cdefine7,@cdefine8,@cdefine9,@cvenaddress,@cvenpostcode,@cvenregcode,@cvoucherstate,@dplanarrdate,@cvenbank,@cvenaccount,@cvenfax,@ccontactcode,@cvenperson,@cappcode,@cvenphone,@cmobilephone,@cdefine10,@cdefine11,@cdefine12,@cdefine13,@cdefine14,@cdefine15,@cdefine16,@cauthid,@cvendefine1,@cvendefine2,@cvendefine3,@cvendefine4,@cvendefine5,@cvendefine6,@cvendefine7,@cvendefine8,@cvendefine9,@cvendefine10,@cvendefine11,@cvendefine12,@cvendefine13,@cvendefine14,@cvendefine15,@cvendefine16,@clocker,@cmaketime,@cmodifytime,@caudittime,@cmodifydate,@cauditdate,@creviser,@cvenpuomprotocol,@cvenpuomprotocolname,@cchangverifier,@cchangaudittime,@cchangauditdate,@cbg_auditor,@cbg_audittime,@controlresult,@ibg_overflag,@iflowid,@cflowname,@bflowprocess,@bstorageorder,@iprintcount,@dclosedate,@dclosetime,@csysbarcode,@ccurrentauditor,@cgcroutecode,@cgcroutename,@bGCTransforming,@yyc_respstatus,@yyc_reason,@csyssource,@csyssourceid,@clshwhcode,@clshwhname,@clshwhphone,@clshwhwhadress)");
            SqlParameter[] parameters = {
                    new SqlParameter("@ivtid", SqlDbType.Int,4),
                    new SqlParameter("@ufts", SqlDbType.Char,30),
                    new SqlParameter("@poid", SqlDbType.Int,4),
                    new SqlParameter("@cchanger", SqlDbType.NVarChar,20),
                    new SqlParameter("@cbustype", SqlDbType.NVarChar,8),
                    new SqlParameter("@cpoid", SqlDbType.NVarChar,30),
                    new SqlParameter("@dpodate", SqlDbType.DateTime),
                    new SqlParameter("@cvencode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdepcode", SqlDbType.NVarChar,12),
                    new SqlParameter("@cpersoncode", SqlDbType.NVarChar,20),
                    new SqlParameter("@carrivalplace", SqlDbType.NVarChar,255),
                    new SqlParameter("@csccode", SqlDbType.NVarChar,2),
                    new SqlParameter("@nflat", SqlDbType.Float,8),
                    new SqlParameter("@itaxrate", SqlDbType.Float,8),
                    new SqlParameter("@cpaycode", SqlDbType.NVarChar,3),
                    new SqlParameter("@icost", SqlDbType.Money,8),
                    new SqlParameter("@ibargain", SqlDbType.Money,8),
                    new SqlParameter("@cmemo", SqlDbType.NVarChar,255),
                    new SqlParameter("@cstate", SqlDbType.TinyInt,1),
                    new SqlParameter("@idiscounttaxtype", SqlDbType.TinyInt,1),
                    new SqlParameter("@cdefine1", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine2", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine3", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenabbname", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdepname", SqlDbType.NVarChar,255),
                    new SqlParameter("@cpayname", SqlDbType.NVarChar,60),
                    new SqlParameter("@cpersonname", SqlDbType.NVarChar,40),
                    new SqlParameter("@cexch_name", SqlDbType.NVarChar,8),
                    new SqlParameter("@cptcode", SqlDbType.NVarChar,2),
                    new SqlParameter("@cperiod", SqlDbType.NVarChar,12),
                    new SqlParameter("@cmaker", SqlDbType.NVarChar,20),
                    new SqlParameter("@ireturncount", SqlDbType.Int,4),
                    new SqlParameter("@iverifystateex", SqlDbType.Int,4),
                    new SqlParameter("@iswfcontrolled", SqlDbType.Bit,1),
                    new SqlParameter("@cverifier", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenname", SqlDbType.NVarChar,98),
                    new SqlParameter("@ccloser", SqlDbType.NVarChar,20),
                    new SqlParameter("@cptname", SqlDbType.NVarChar,20),
                    new SqlParameter("@cscname", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine4", SqlDbType.DateTime),
                    new SqlParameter("@cdefine5", SqlDbType.Int,4),
                    new SqlParameter("@cdefine6", SqlDbType.DateTime),
                    new SqlParameter("@cdefine7", SqlDbType.Float,8),
                    new SqlParameter("@cdefine8", SqlDbType.NVarChar,4),
                    new SqlParameter("@cdefine9", SqlDbType.NVarChar,8),
                    new SqlParameter("@cvenaddress", SqlDbType.NVarChar,255),
                    new SqlParameter("@cvenpostcode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenregcode", SqlDbType.NVarChar,50),
                    new SqlParameter("@cvoucherstate", SqlDbType.NVarChar,5),
                    new SqlParameter("@dplanarrdate", SqlDbType.Int,4),
                    new SqlParameter("@cvenbank", SqlDbType.NVarChar,200),
                    new SqlParameter("@cvenaccount", SqlDbType.NVarChar,100),
                    new SqlParameter("@cvenfax", SqlDbType.NVarChar,100),
                    new SqlParameter("@ccontactcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvenperson", SqlDbType.NVarChar,100),
                    new SqlParameter("@cappcode", SqlDbType.NVarChar,64),
                    new SqlParameter("@cvenphone", SqlDbType.NVarChar,100),
                    new SqlParameter("@cmobilephone", SqlDbType.NVarChar,100),
                    new SqlParameter("@cdefine10", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdefine11", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine12", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine13", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine14", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine15", SqlDbType.Int,4),
                    new SqlParameter("@cdefine16", SqlDbType.Float,8),
                    new SqlParameter("@cauthid", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine1", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvendefine2", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvendefine3", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvendefine4", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvendefine5", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvendefine6", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvendefine7", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine8", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine9", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine10", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine11", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine12", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine13", SqlDbType.Float,8),
                    new SqlParameter("@cvendefine14", SqlDbType.Float,8),
                    new SqlParameter("@cvendefine15", SqlDbType.DateTime),
                    new SqlParameter("@cvendefine16", SqlDbType.DateTime),
                    new SqlParameter("@clocker", SqlDbType.NVarChar,20),
                    new SqlParameter("@cmaketime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifytime", SqlDbType.DateTime),
                    new SqlParameter("@caudittime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifydate", SqlDbType.DateTime),
                    new SqlParameter("@cauditdate", SqlDbType.DateTime),
                    new SqlParameter("@creviser", SqlDbType.NVarChar,40),
                    new SqlParameter("@cvenpuomprotocol", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenpuomprotocolname", SqlDbType.NVarChar,60),
                    new SqlParameter("@cchangverifier", SqlDbType.NVarChar,40),
                    new SqlParameter("@cchangaudittime", SqlDbType.DateTime),
                    new SqlParameter("@cchangauditdate", SqlDbType.DateTime),
                    new SqlParameter("@cbg_auditor", SqlDbType.NVarChar,20),
                    new SqlParameter("@cbg_audittime", SqlDbType.NVarChar,20),
                    new SqlParameter("@controlresult", SqlDbType.SmallInt,2),
                    new SqlParameter("@ibg_overflag", SqlDbType.SmallInt,2),
                    new SqlParameter("@iflowid", SqlDbType.Int,4),
                    new SqlParameter("@cflowname", SqlDbType.NVarChar,40),
                    new SqlParameter("@bflowprocess", SqlDbType.Bit,1),
                    new SqlParameter("@bstorageorder", SqlDbType.Bit,1),
                    new SqlParameter("@iprintcount", SqlDbType.Int,4),
                    new SqlParameter("@dclosedate", SqlDbType.DateTime),
                    new SqlParameter("@dclosetime", SqlDbType.DateTime),
                    new SqlParameter("@csysbarcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@ccurrentauditor", SqlDbType.NVarChar,200),
                    new SqlParameter("@cgcroutecode", SqlDbType.NVarChar,10),
                    new SqlParameter("@cgcroutename", SqlDbType.NVarChar,100),
                    new SqlParameter("@bGCTransforming", SqlDbType.Bit,1),
                    new SqlParameter("@yyc_respstatus", SqlDbType.NVarChar,20),
                    new SqlParameter("@yyc_reason", SqlDbType.NVarChar,255),
                    new SqlParameter("@csyssource", SqlDbType.NVarChar,10),
                    new SqlParameter("@csyssourceid", SqlDbType.NVarChar,50),
                    new SqlParameter("@clshwhcode", SqlDbType.NVarChar,10),
                    new SqlParameter("@clshwhname", SqlDbType.NVarChar,20),
                    new SqlParameter("@clshwhphone", SqlDbType.NVarChar,100),
                    new SqlParameter("@clshwhwhadress", SqlDbType.NVarChar,255)};
            parameters[0].Value = ivtid;
            parameters[1].Value = ufts;
            parameters[2].Value = poid;
            parameters[3].Value = cchanger;
            parameters[4].Value = cbustype;
            parameters[5].Value = cpoid;
            parameters[6].Value = dpodate;
            parameters[7].Value = cvencode;
            parameters[8].Value = cdepcode;
            parameters[9].Value = cpersoncode;
            parameters[10].Value = carrivalplace;
            parameters[11].Value = csccode;
            parameters[12].Value = nflat;
            parameters[13].Value = itaxrate;
            parameters[14].Value = cpaycode;
            parameters[15].Value = icost;
            parameters[16].Value = ibargain;
            parameters[17].Value = cmemo;
            parameters[18].Value = cstate;
            parameters[19].Value = idiscounttaxtype;
            parameters[20].Value = cdefine1;
            parameters[21].Value = cdefine2;
            parameters[22].Value = cdefine3;
            parameters[23].Value = cvenabbname;
            parameters[24].Value = cdepname;
            parameters[25].Value = cpayname;
            parameters[26].Value = cpersonname;
            parameters[27].Value = cexch_name;
            parameters[28].Value = cptcode;
            parameters[29].Value = cperiod;
            parameters[30].Value = cmaker;
            parameters[31].Value = ireturncount;
            parameters[32].Value = iverifystateex;
            parameters[33].Value = iswfcontrolled;
            parameters[34].Value = cverifier;
            parameters[35].Value = cvenname;
            parameters[36].Value = ccloser;
            parameters[37].Value = cptname;
            parameters[38].Value = cscname;
            parameters[39].Value = cdefine4;
            parameters[40].Value = cdefine5;
            parameters[41].Value = cdefine6;
            parameters[42].Value = cdefine7;
            parameters[43].Value = cdefine8;
            parameters[44].Value = cdefine9;
            parameters[45].Value = cvenaddress;
            parameters[46].Value = cvenpostcode;
            parameters[47].Value = cvenregcode;
            parameters[48].Value = cvoucherstate;
            parameters[49].Value = dplanarrdate;
            parameters[50].Value = cvenbank;
            parameters[51].Value = cvenaccount;
            parameters[52].Value = cvenfax;
            parameters[53].Value = ccontactcode;
            parameters[54].Value = cvenperson;
            parameters[55].Value = cappcode;
            parameters[56].Value = cvenphone;
            parameters[57].Value = cmobilephone;
            parameters[58].Value = cdefine10;
            parameters[59].Value = cdefine11;
            parameters[60].Value = cdefine12;
            parameters[61].Value = cdefine13;
            parameters[62].Value = cdefine14;
            parameters[63].Value = cdefine15;
            parameters[64].Value = cdefine16;
            parameters[65].Value = cauthid;
            parameters[66].Value = cvendefine1;
            parameters[67].Value = cvendefine2;
            parameters[68].Value = cvendefine3;
            parameters[69].Value = cvendefine4;
            parameters[70].Value = cvendefine5;
            parameters[71].Value = cvendefine6;
            parameters[72].Value = cvendefine7;
            parameters[73].Value = cvendefine8;
            parameters[74].Value = cvendefine9;
            parameters[75].Value = cvendefine10;
            parameters[76].Value = cvendefine11;
            parameters[77].Value = cvendefine12;
            parameters[78].Value = cvendefine13;
            parameters[79].Value = cvendefine14;
            parameters[80].Value = cvendefine15;
            parameters[81].Value = cvendefine16;
            parameters[82].Value = clocker;
            parameters[83].Value = cmaketime;
            parameters[84].Value = cmodifytime;
            parameters[85].Value = caudittime;
            parameters[86].Value = cmodifydate;
            parameters[87].Value = cauditdate;
            parameters[88].Value = creviser;
            parameters[89].Value = cvenpuomprotocol;
            parameters[90].Value = cvenpuomprotocolname;
            parameters[91].Value = cchangverifier;
            parameters[92].Value = cchangaudittime;
            parameters[93].Value = cchangauditdate;
            parameters[94].Value = cbg_auditor;
            parameters[95].Value = cbg_audittime;
            parameters[96].Value = controlresult;
            parameters[97].Value = ibg_overflag;
            parameters[98].Value = iflowid;
            parameters[99].Value = cflowname;
            parameters[100].Value = bflowprocess;
            parameters[101].Value = bstorageorder;
            parameters[102].Value = iprintcount;
            parameters[103].Value = dclosedate;
            parameters[104].Value = dclosetime;
            parameters[105].Value = csysbarcode;
            parameters[106].Value = ccurrentauditor;
            parameters[107].Value = cgcroutecode;
            parameters[108].Value = cgcroutename;
            parameters[109].Value = bGCTransforming;
            parameters[110].Value = yyc_respstatus;
            parameters[111].Value = yyc_reason;
            parameters[112].Value = csyssource;
            parameters[113].Value = csyssourceid;
            parameters[114].Value = clshwhcode;
            parameters[115].Value = clshwhname;
            parameters[116].Value = clshwhphone;
            parameters[117].Value = clshwhwhadress;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update [zpurpoheader] set ");
            strSql.Append("ivtid=@ivtid,");
            strSql.Append("ufts=@ufts,");
            strSql.Append("poid=@poid,");
            strSql.Append("cchanger=@cchanger,");
            strSql.Append("cbustype=@cbustype,");
            strSql.Append("cpoid=@cpoid,");
            strSql.Append("dpodate=@dpodate,");
            strSql.Append("cvencode=@cvencode,");
            strSql.Append("cdepcode=@cdepcode,");
            strSql.Append("cpersoncode=@cpersoncode,");
            strSql.Append("carrivalplace=@carrivalplace,");
            strSql.Append("csccode=@csccode,");
            strSql.Append("nflat=@nflat,");
            strSql.Append("itaxrate=@itaxrate,");
            strSql.Append("cpaycode=@cpaycode,");
            strSql.Append("icost=@icost,");
            strSql.Append("ibargain=@ibargain,");
            strSql.Append("cmemo=@cmemo,");
            strSql.Append("cstate=@cstate,");
            strSql.Append("idiscounttaxtype=@idiscounttaxtype,");
            strSql.Append("cdefine1=@cdefine1,");
            strSql.Append("cdefine2=@cdefine2,");
            strSql.Append("cdefine3=@cdefine3,");
            strSql.Append("cvenabbname=@cvenabbname,");
            strSql.Append("cdepname=@cdepname,");
            strSql.Append("cpayname=@cpayname,");
            strSql.Append("cpersonname=@cpersonname,");
            strSql.Append("cexch_name=@cexch_name,");
            strSql.Append("cptcode=@cptcode,");
            strSql.Append("cperiod=@cperiod,");
            strSql.Append("cmaker=@cmaker,");
            strSql.Append("ireturncount=@ireturncount,");
            strSql.Append("iverifystateex=@iverifystateex,");
            strSql.Append("iswfcontrolled=@iswfcontrolled,");
            strSql.Append("cverifier=@cverifier,");
            strSql.Append("cvenname=@cvenname,");
            strSql.Append("ccloser=@ccloser,");
            strSql.Append("cptname=@cptname,");
            strSql.Append("cscname=@cscname,");
            strSql.Append("cdefine4=@cdefine4,");
            strSql.Append("cdefine5=@cdefine5,");
            strSql.Append("cdefine6=@cdefine6,");
            strSql.Append("cdefine7=@cdefine7,");
            strSql.Append("cdefine8=@cdefine8,");
            strSql.Append("cdefine9=@cdefine9,");
            strSql.Append("cvenaddress=@cvenaddress,");
            strSql.Append("cvenpostcode=@cvenpostcode,");
            strSql.Append("cvenregcode=@cvenregcode,");
            strSql.Append("cvoucherstate=@cvoucherstate,");
            strSql.Append("dplanarrdate=@dplanarrdate,");
            strSql.Append("cvenbank=@cvenbank,");
            strSql.Append("cvenaccount=@cvenaccount,");
            strSql.Append("cvenfax=@cvenfax,");
            strSql.Append("ccontactcode=@ccontactcode,");
            strSql.Append("cvenperson=@cvenperson,");
            strSql.Append("cappcode=@cappcode,");
            strSql.Append("cvenphone=@cvenphone,");
            strSql.Append("cmobilephone=@cmobilephone,");
            strSql.Append("cdefine10=@cdefine10,");
            strSql.Append("cdefine11=@cdefine11,");
            strSql.Append("cdefine12=@cdefine12,");
            strSql.Append("cdefine13=@cdefine13,");
            strSql.Append("cdefine14=@cdefine14,");
            strSql.Append("cdefine15=@cdefine15,");
            strSql.Append("cdefine16=@cdefine16,");
            strSql.Append("cauthid=@cauthid,");
            strSql.Append("cvendefine1=@cvendefine1,");
            strSql.Append("cvendefine2=@cvendefine2,");
            strSql.Append("cvendefine3=@cvendefine3,");
            strSql.Append("cvendefine4=@cvendefine4,");
            strSql.Append("cvendefine5=@cvendefine5,");
            strSql.Append("cvendefine6=@cvendefine6,");
            strSql.Append("cvendefine7=@cvendefine7,");
            strSql.Append("cvendefine8=@cvendefine8,");
            strSql.Append("cvendefine9=@cvendefine9,");
            strSql.Append("cvendefine10=@cvendefine10,");
            strSql.Append("cvendefine11=@cvendefine11,");
            strSql.Append("cvendefine12=@cvendefine12,");
            strSql.Append("cvendefine13=@cvendefine13,");
            strSql.Append("cvendefine14=@cvendefine14,");
            strSql.Append("cvendefine15=@cvendefine15,");
            strSql.Append("cvendefine16=@cvendefine16,");
            strSql.Append("clocker=@clocker,");
            strSql.Append("cmaketime=@cmaketime,");
            strSql.Append("cmodifytime=@cmodifytime,");
            strSql.Append("caudittime=@caudittime,");
            strSql.Append("cmodifydate=@cmodifydate,");
            strSql.Append("cauditdate=@cauditdate,");
            strSql.Append("creviser=@creviser,");
            strSql.Append("cvenpuomprotocol=@cvenpuomprotocol,");
            strSql.Append("cvenpuomprotocolname=@cvenpuomprotocolname,");
            strSql.Append("cchangverifier=@cchangverifier,");
            strSql.Append("cchangaudittime=@cchangaudittime,");
            strSql.Append("cchangauditdate=@cchangauditdate,");
            strSql.Append("cbg_auditor=@cbg_auditor,");
            strSql.Append("cbg_audittime=@cbg_audittime,");
            strSql.Append("controlresult=@controlresult,");
            strSql.Append("ibg_overflag=@ibg_overflag,");
            strSql.Append("iflowid=@iflowid,");
            strSql.Append("cflowname=@cflowname,");
            strSql.Append("bflowprocess=@bflowprocess,");
            strSql.Append("bstorageorder=@bstorageorder,");
            strSql.Append("iprintcount=@iprintcount,");
            strSql.Append("dclosedate=@dclosedate,");
            strSql.Append("dclosetime=@dclosetime,");
            strSql.Append("csysbarcode=@csysbarcode,");
            strSql.Append("ccurrentauditor=@ccurrentauditor,");
            strSql.Append("cgcroutecode=@cgcroutecode,");
            strSql.Append("cgcroutename=@cgcroutename,");
            strSql.Append("bGCTransforming=@bGCTransforming,");
            strSql.Append("yyc_respstatus=@yyc_respstatus,");
            strSql.Append("yyc_reason=@yyc_reason,");
            strSql.Append("csyssource=@csyssource,");
            strSql.Append("csyssourceid=@csyssourceid,");
            strSql.Append("clshwhcode=@clshwhcode,");
            strSql.Append("clshwhname=@clshwhname,");
            strSql.Append("clshwhphone=@clshwhphone,");
            strSql.Append("clshwhwhadress=@clshwhwhadress");
            strSql.Append(" where ivtid=@ivtid and ufts=@ufts and poid=@poid and cchanger=@cchanger and cbustype=@cbustype and cpoid=@cpoid and dpodate=@dpodate and cvencode=@cvencode and cdepcode=@cdepcode and cpersoncode=@cpersoncode and carrivalplace=@carrivalplace and csccode=@csccode and nflat=@nflat and itaxrate=@itaxrate and cpaycode=@cpaycode and icost=@icost and ibargain=@ibargain and cmemo=@cmemo and cstate=@cstate and idiscounttaxtype=@idiscounttaxtype and cdefine1=@cdefine1 and cdefine2=@cdefine2 and cdefine3=@cdefine3 and cvenabbname=@cvenabbname and cdepname=@cdepname and cpayname=@cpayname and cpersonname=@cpersonname and cexch_name=@cexch_name and cptcode=@cptcode and cperiod=@cperiod and cmaker=@cmaker and ireturncount=@ireturncount and iverifystateex=@iverifystateex and iswfcontrolled=@iswfcontrolled and cverifier=@cverifier and cvenname=@cvenname and ccloser=@ccloser and cptname=@cptname and cscname=@cscname and cdefine4=@cdefine4 and cdefine5=@cdefine5 and cdefine6=@cdefine6 and cdefine7=@cdefine7 and cdefine8=@cdefine8 and cdefine9=@cdefine9 and cvenaddress=@cvenaddress and cvenpostcode=@cvenpostcode and cvenregcode=@cvenregcode and cvoucherstate=@cvoucherstate and dplanarrdate=@dplanarrdate and cvenbank=@cvenbank and cvenaccount=@cvenaccount and cvenfax=@cvenfax and ccontactcode=@ccontactcode and cvenperson=@cvenperson and cappcode=@cappcode and cvenphone=@cvenphone and cmobilephone=@cmobilephone and cdefine10=@cdefine10 and cdefine11=@cdefine11 and cdefine12=@cdefine12 and cdefine13=@cdefine13 and cdefine14=@cdefine14 and cdefine15=@cdefine15 and cdefine16=@cdefine16 and cauthid=@cauthid and cvendefine1=@cvendefine1 and cvendefine2=@cvendefine2 and cvendefine3=@cvendefine3 and cvendefine4=@cvendefine4 and cvendefine5=@cvendefine5 and cvendefine6=@cvendefine6 and cvendefine7=@cvendefine7 and cvendefine8=@cvendefine8 and cvendefine9=@cvendefine9 and cvendefine10=@cvendefine10 and cvendefine11=@cvendefine11 and cvendefine12=@cvendefine12 and cvendefine13=@cvendefine13 and cvendefine14=@cvendefine14 and cvendefine15=@cvendefine15 and cvendefine16=@cvendefine16 and clocker=@clocker and cmaketime=@cmaketime and cmodifytime=@cmodifytime and caudittime=@caudittime and cmodifydate=@cmodifydate and cauditdate=@cauditdate and creviser=@creviser and cvenpuomprotocol=@cvenpuomprotocol and cvenpuomprotocolname=@cvenpuomprotocolname and cchangverifier=@cchangverifier and cchangaudittime=@cchangaudittime and cchangauditdate=@cchangauditdate and cbg_auditor=@cbg_auditor and cbg_audittime=@cbg_audittime and controlresult=@controlresult and ibg_overflag=@ibg_overflag and iflowid=@iflowid and cflowname=@cflowname and bflowprocess=@bflowprocess and bstorageorder=@bstorageorder and iprintcount=@iprintcount and dclosedate=@dclosedate and dclosetime=@dclosetime and csysbarcode=@csysbarcode and ccurrentauditor=@ccurrentauditor and cgcroutecode=@cgcroutecode and cgcroutename=@cgcroutename and bGCTransforming=@bGCTransforming and yyc_respstatus=@yyc_respstatus and yyc_reason=@yyc_reason and csyssource=@csyssource and csyssourceid=@csyssourceid and clshwhcode=@clshwhcode and clshwhname=@clshwhname and clshwhphone=@clshwhphone and clshwhwhadress=@clshwhwhadress ");
            SqlParameter[] parameters = {
                    new SqlParameter("@ivtid", SqlDbType.Int,4),
                    new SqlParameter("@ufts", SqlDbType.Char,30),
                    new SqlParameter("@poid", SqlDbType.Int,4),
                    new SqlParameter("@cchanger", SqlDbType.NVarChar,20),
                    new SqlParameter("@cbustype", SqlDbType.NVarChar,8),
                    new SqlParameter("@cpoid", SqlDbType.NVarChar,30),
                    new SqlParameter("@dpodate", SqlDbType.DateTime),
                    new SqlParameter("@cvencode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdepcode", SqlDbType.NVarChar,12),
                    new SqlParameter("@cpersoncode", SqlDbType.NVarChar,20),
                    new SqlParameter("@carrivalplace", SqlDbType.NVarChar,255),
                    new SqlParameter("@csccode", SqlDbType.NVarChar,2),
                    new SqlParameter("@nflat", SqlDbType.Float,8),
                    new SqlParameter("@itaxrate", SqlDbType.Float,8),
                    new SqlParameter("@cpaycode", SqlDbType.NVarChar,3),
                    new SqlParameter("@icost", SqlDbType.Money,8),
                    new SqlParameter("@ibargain", SqlDbType.Money,8),
                    new SqlParameter("@cmemo", SqlDbType.NVarChar,255),
                    new SqlParameter("@cstate", SqlDbType.TinyInt,1),
                    new SqlParameter("@idiscounttaxtype", SqlDbType.TinyInt,1),
                    new SqlParameter("@cdefine1", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine2", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine3", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenabbname", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdepname", SqlDbType.NVarChar,255),
                    new SqlParameter("@cpayname", SqlDbType.NVarChar,60),
                    new SqlParameter("@cpersonname", SqlDbType.NVarChar,40),
                    new SqlParameter("@cexch_name", SqlDbType.NVarChar,8),
                    new SqlParameter("@cptcode", SqlDbType.NVarChar,2),
                    new SqlParameter("@cperiod", SqlDbType.NVarChar,12),
                    new SqlParameter("@cmaker", SqlDbType.NVarChar,20),
                    new SqlParameter("@ireturncount", SqlDbType.Int,4),
                    new SqlParameter("@iverifystateex", SqlDbType.Int,4),
                    new SqlParameter("@iswfcontrolled", SqlDbType.Bit,1),
                    new SqlParameter("@cverifier", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenname", SqlDbType.NVarChar,98),
                    new SqlParameter("@ccloser", SqlDbType.NVarChar,20),
                    new SqlParameter("@cptname", SqlDbType.NVarChar,20),
                    new SqlParameter("@cscname", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine4", SqlDbType.DateTime),
                    new SqlParameter("@cdefine5", SqlDbType.Int,4),
                    new SqlParameter("@cdefine6", SqlDbType.DateTime),
                    new SqlParameter("@cdefine7", SqlDbType.Float,8),
                    new SqlParameter("@cdefine8", SqlDbType.NVarChar,4),
                    new SqlParameter("@cdefine9", SqlDbType.NVarChar,8),
                    new SqlParameter("@cvenaddress", SqlDbType.NVarChar,255),
                    new SqlParameter("@cvenpostcode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenregcode", SqlDbType.NVarChar,50),
                    new SqlParameter("@cvoucherstate", SqlDbType.NVarChar,5),
                    new SqlParameter("@dplanarrdate", SqlDbType.Int,4),
                    new SqlParameter("@cvenbank", SqlDbType.NVarChar,200),
                    new SqlParameter("@cvenaccount", SqlDbType.NVarChar,100),
                    new SqlParameter("@cvenfax", SqlDbType.NVarChar,100),
                    new SqlParameter("@ccontactcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvenperson", SqlDbType.NVarChar,100),
                    new SqlParameter("@cappcode", SqlDbType.NVarChar,64),
                    new SqlParameter("@cvenphone", SqlDbType.NVarChar,100),
                    new SqlParameter("@cmobilephone", SqlDbType.NVarChar,100),
                    new SqlParameter("@cdefine10", SqlDbType.NVarChar,60),
                    new SqlParameter("@cdefine11", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine12", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine13", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine14", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine15", SqlDbType.Int,4),
                    new SqlParameter("@cdefine16", SqlDbType.Float,8),
                    new SqlParameter("@cauthid", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine1", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvendefine2", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvendefine3", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvendefine4", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvendefine5", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvendefine6", SqlDbType.NVarChar,60),
                    new SqlParameter("@cvendefine7", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine8", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine9", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine10", SqlDbType.NVarChar,120),
                    new SqlParameter("@cvendefine11", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine12", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine13", SqlDbType.Float,8),
                    new SqlParameter("@cvendefine14", SqlDbType.Float,8),
                    new SqlParameter("@cvendefine15", SqlDbType.DateTime),
                    new SqlParameter("@cvendefine16", SqlDbType.DateTime),
                    new SqlParameter("@clocker", SqlDbType.NVarChar,20),
                    new SqlParameter("@cmaketime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifytime", SqlDbType.DateTime),
                    new SqlParameter("@caudittime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifydate", SqlDbType.DateTime),
                    new SqlParameter("@cauditdate", SqlDbType.DateTime),
                    new SqlParameter("@creviser", SqlDbType.NVarChar,40),
                    new SqlParameter("@cvenpuomprotocol", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenpuomprotocolname", SqlDbType.NVarChar,60),
                    new SqlParameter("@cchangverifier", SqlDbType.NVarChar,40),
                    new SqlParameter("@cchangaudittime", SqlDbType.DateTime),
                    new SqlParameter("@cchangauditdate", SqlDbType.DateTime),
                    new SqlParameter("@cbg_auditor", SqlDbType.NVarChar,20),
                    new SqlParameter("@cbg_audittime", SqlDbType.NVarChar,20),
                    new SqlParameter("@controlresult", SqlDbType.SmallInt,2),
                    new SqlParameter("@ibg_overflag", SqlDbType.SmallInt,2),
                    new SqlParameter("@iflowid", SqlDbType.Int,4),
                    new SqlParameter("@cflowname", SqlDbType.NVarChar,40),
                    new SqlParameter("@bflowprocess", SqlDbType.Bit,1),
                    new SqlParameter("@bstorageorder", SqlDbType.Bit,1),
                    new SqlParameter("@iprintcount", SqlDbType.Int,4),
                    new SqlParameter("@dclosedate", SqlDbType.DateTime),
                    new SqlParameter("@dclosetime", SqlDbType.DateTime),
                    new SqlParameter("@csysbarcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@ccurrentauditor", SqlDbType.NVarChar,200),
                    new SqlParameter("@cgcroutecode", SqlDbType.NVarChar,10),
                    new SqlParameter("@cgcroutename", SqlDbType.NVarChar,100),
                    new SqlParameter("@bGCTransforming", SqlDbType.Bit,1),
                    new SqlParameter("@yyc_respstatus", SqlDbType.NVarChar,20),
                    new SqlParameter("@yyc_reason", SqlDbType.NVarChar,255),
                    new SqlParameter("@csyssource", SqlDbType.NVarChar,10),
                    new SqlParameter("@csyssourceid", SqlDbType.NVarChar,50),
                    new SqlParameter("@clshwhcode", SqlDbType.NVarChar,10),
                    new SqlParameter("@clshwhname", SqlDbType.NVarChar,20),
                    new SqlParameter("@clshwhphone", SqlDbType.NVarChar,100),
                    new SqlParameter("@clshwhwhadress", SqlDbType.NVarChar,255)};
            parameters[0].Value = ivtid;
            parameters[1].Value = ufts;
            parameters[2].Value = poid;
            parameters[3].Value = cchanger;
            parameters[4].Value = cbustype;
            parameters[5].Value = cpoid;
            parameters[6].Value = dpodate;
            parameters[7].Value = cvencode;
            parameters[8].Value = cdepcode;
            parameters[9].Value = cpersoncode;
            parameters[10].Value = carrivalplace;
            parameters[11].Value = csccode;
            parameters[12].Value = nflat;
            parameters[13].Value = itaxrate;
            parameters[14].Value = cpaycode;
            parameters[15].Value = icost;
            parameters[16].Value = ibargain;
            parameters[17].Value = cmemo;
            parameters[18].Value = cstate;
            parameters[19].Value = idiscounttaxtype;
            parameters[20].Value = cdefine1;
            parameters[21].Value = cdefine2;
            parameters[22].Value = cdefine3;
            parameters[23].Value = cvenabbname;
            parameters[24].Value = cdepname;
            parameters[25].Value = cpayname;
            parameters[26].Value = cpersonname;
            parameters[27].Value = cexch_name;
            parameters[28].Value = cptcode;
            parameters[29].Value = cperiod;
            parameters[30].Value = cmaker;
            parameters[31].Value = ireturncount;
            parameters[32].Value = iverifystateex;
            parameters[33].Value = iswfcontrolled;
            parameters[34].Value = cverifier;
            parameters[35].Value = cvenname;
            parameters[36].Value = ccloser;
            parameters[37].Value = cptname;
            parameters[38].Value = cscname;
            parameters[39].Value = cdefine4;
            parameters[40].Value = cdefine5;
            parameters[41].Value = cdefine6;
            parameters[42].Value = cdefine7;
            parameters[43].Value = cdefine8;
            parameters[44].Value = cdefine9;
            parameters[45].Value = cvenaddress;
            parameters[46].Value = cvenpostcode;
            parameters[47].Value = cvenregcode;
            parameters[48].Value = cvoucherstate;
            parameters[49].Value = dplanarrdate;
            parameters[50].Value = cvenbank;
            parameters[51].Value = cvenaccount;
            parameters[52].Value = cvenfax;
            parameters[53].Value = ccontactcode;
            parameters[54].Value = cvenperson;
            parameters[55].Value = cappcode;
            parameters[56].Value = cvenphone;
            parameters[57].Value = cmobilephone;
            parameters[58].Value = cdefine10;
            parameters[59].Value = cdefine11;
            parameters[60].Value = cdefine12;
            parameters[61].Value = cdefine13;
            parameters[62].Value = cdefine14;
            parameters[63].Value = cdefine15;
            parameters[64].Value = cdefine16;
            parameters[65].Value = cauthid;
            parameters[66].Value = cvendefine1;
            parameters[67].Value = cvendefine2;
            parameters[68].Value = cvendefine3;
            parameters[69].Value = cvendefine4;
            parameters[70].Value = cvendefine5;
            parameters[71].Value = cvendefine6;
            parameters[72].Value = cvendefine7;
            parameters[73].Value = cvendefine8;
            parameters[74].Value = cvendefine9;
            parameters[75].Value = cvendefine10;
            parameters[76].Value = cvendefine11;
            parameters[77].Value = cvendefine12;
            parameters[78].Value = cvendefine13;
            parameters[79].Value = cvendefine14;
            parameters[80].Value = cvendefine15;
            parameters[81].Value = cvendefine16;
            parameters[82].Value = clocker;
            parameters[83].Value = cmaketime;
            parameters[84].Value = cmodifytime;
            parameters[85].Value = caudittime;
            parameters[86].Value = cmodifydate;
            parameters[87].Value = cauditdate;
            parameters[88].Value = creviser;
            parameters[89].Value = cvenpuomprotocol;
            parameters[90].Value = cvenpuomprotocolname;
            parameters[91].Value = cchangverifier;
            parameters[92].Value = cchangaudittime;
            parameters[93].Value = cchangauditdate;
            parameters[94].Value = cbg_auditor;
            parameters[95].Value = cbg_audittime;
            parameters[96].Value = controlresult;
            parameters[97].Value = ibg_overflag;
            parameters[98].Value = iflowid;
            parameters[99].Value = cflowname;
            parameters[100].Value = bflowprocess;
            parameters[101].Value = bstorageorder;
            parameters[102].Value = iprintcount;
            parameters[103].Value = dclosedate;
            parameters[104].Value = dclosetime;
            parameters[105].Value = csysbarcode;
            parameters[106].Value = ccurrentauditor;
            parameters[107].Value = cgcroutecode;
            parameters[108].Value = cgcroutename;
            parameters[109].Value = bGCTransforming;
            parameters[110].Value = yyc_respstatus;
            parameters[111].Value = yyc_reason;
            parameters[112].Value = csyssource;
            parameters[113].Value = csyssourceid;
            parameters[114].Value = clshwhcode;
            parameters[115].Value = clshwhname;
            parameters[116].Value = clshwhphone;
            parameters[117].Value = clshwhwhadress;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int ivtid, string ufts, int poid, string cchanger, string cbustype, string cpoid, DateTime dpodate, string cvencode, string cdepcode, string cpersoncode, string carrivalplace, string csccode, decimal nflat, decimal itaxrate, string cpaycode, decimal icost, decimal ibargain, string cmemo, int cstate, int idiscounttaxtype, string cdefine1, string cdefine2, string cdefine3, string cvenabbname, string cdepname, string cpayname, string cpersonname, string cexch_name, string cptcode, string cperiod, string cmaker, int ireturncount, int iverifystateex, bool iswfcontrolled, string cverifier, string cvenname, string ccloser, string cptname, string cscname, DateTime cdefine4, int cdefine5, DateTime cdefine6, decimal cdefine7, string cdefine8, string cdefine9, string cvenaddress, string cvenpostcode, string cvenregcode, string cvoucherstate, int dplanarrdate, string cvenbank, string cvenaccount, string cvenfax, string ccontactcode, string cvenperson, string cappcode, string cvenphone, string cmobilephone, string cdefine10, string cdefine11, string cdefine12, string cdefine13, string cdefine14, int cdefine15, decimal cdefine16, int cauthid, string cvendefine1, string cvendefine2, string cvendefine3, string cvendefine4, string cvendefine5, string cvendefine6, string cvendefine7, string cvendefine8, string cvendefine9, string cvendefine10, int cvendefine11, int cvendefine12, decimal cvendefine13, decimal cvendefine14, DateTime cvendefine15, DateTime cvendefine16, string clocker, DateTime cmaketime, DateTime cmodifytime, DateTime caudittime, DateTime cmodifydate, DateTime cauditdate, string creviser, string cvenpuomprotocol, string cvenpuomprotocolname, string cchangverifier, DateTime cchangaudittime, DateTime cchangauditdate, string cbg_auditor, string cbg_audittime, int controlresult, int ibg_overflag, int iflowid, string cflowname, bool bflowprocess, bool bstorageorder, int iprintcount, DateTime dclosedate, DateTime dclosetime, string csysbarcode, string ccurrentauditor, string cgcroutecode, string cgcroutename, bool bGCTransforming, string yyc_respstatus, string yyc_reason, string csyssource, string csyssourceid, string clshwhcode, string clshwhname, string clshwhphone, string clshwhwhadress)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from [zpurpoheader] ");
            strSql.Append(" where ivtid=@ivtid and ufts=@ufts and poid=@poid and cchanger=@cchanger and cbustype=@cbustype and cpoid=@cpoid and dpodate=@dpodate and cvencode=@cvencode and cdepcode=@cdepcode and cpersoncode=@cpersoncode and carrivalplace=@carrivalplace and csccode=@csccode and nflat=@nflat and itaxrate=@itaxrate and cpaycode=@cpaycode and icost=@icost and ibargain=@ibargain and cmemo=@cmemo and cstate=@cstate and idiscounttaxtype=@idiscounttaxtype and cdefine1=@cdefine1 and cdefine2=@cdefine2 and cdefine3=@cdefine3 and cvenabbname=@cvenabbname and cdepname=@cdepname and cpayname=@cpayname and cpersonname=@cpersonname and cexch_name=@cexch_name and cptcode=@cptcode and cperiod=@cperiod and cmaker=@cmaker and ireturncount=@ireturncount and iverifystateex=@iverifystateex and iswfcontrolled=@iswfcontrolled and cverifier=@cverifier and cvenname=@cvenname and ccloser=@ccloser and cptname=@cptname and cscname=@cscname and cdefine4=@cdefine4 and cdefine5=@cdefine5 and cdefine6=@cdefine6 and cdefine7=@cdefine7 and cdefine8=@cdefine8 and cdefine9=@cdefine9 and cvenaddress=@cvenaddress and cvenpostcode=@cvenpostcode and cvenregcode=@cvenregcode and cvoucherstate=@cvoucherstate and dplanarrdate=@dplanarrdate and cvenbank=@cvenbank and cvenaccount=@cvenaccount and cvenfax=@cvenfax and ccontactcode=@ccontactcode and cvenperson=@cvenperson and cappcode=@cappcode and cvenphone=@cvenphone and cmobilephone=@cmobilephone and cdefine10=@cdefine10 and cdefine11=@cdefine11 and cdefine12=@cdefine12 and cdefine13=@cdefine13 and cdefine14=@cdefine14 and cdefine15=@cdefine15 and cdefine16=@cdefine16 and cauthid=@cauthid and cvendefine1=@cvendefine1 and cvendefine2=@cvendefine2 and cvendefine3=@cvendefine3 and cvendefine4=@cvendefine4 and cvendefine5=@cvendefine5 and cvendefine6=@cvendefine6 and cvendefine7=@cvendefine7 and cvendefine8=@cvendefine8 and cvendefine9=@cvendefine9 and cvendefine10=@cvendefine10 and cvendefine11=@cvendefine11 and cvendefine12=@cvendefine12 and cvendefine13=@cvendefine13 and cvendefine14=@cvendefine14 and cvendefine15=@cvendefine15 and cvendefine16=@cvendefine16 and clocker=@clocker and cmaketime=@cmaketime and cmodifytime=@cmodifytime and caudittime=@caudittime and cmodifydate=@cmodifydate and cauditdate=@cauditdate and creviser=@creviser and cvenpuomprotocol=@cvenpuomprotocol and cvenpuomprotocolname=@cvenpuomprotocolname and cchangverifier=@cchangverifier and cchangaudittime=@cchangaudittime and cchangauditdate=@cchangauditdate and cbg_auditor=@cbg_auditor and cbg_audittime=@cbg_audittime and controlresult=@controlresult and ibg_overflag=@ibg_overflag and iflowid=@iflowid and cflowname=@cflowname and bflowprocess=@bflowprocess and bstorageorder=@bstorageorder and iprintcount=@iprintcount and dclosedate=@dclosedate and dclosetime=@dclosetime and csysbarcode=@csysbarcode and ccurrentauditor=@ccurrentauditor and cgcroutecode=@cgcroutecode and cgcroutename=@cgcroutename and bGCTransforming=@bGCTransforming and yyc_respstatus=@yyc_respstatus and yyc_reason=@yyc_reason and csyssource=@csyssource and csyssourceid=@csyssourceid and clshwhcode=@clshwhcode and clshwhname=@clshwhname and clshwhphone=@clshwhphone and clshwhwhadress=@clshwhwhadress ");
            SqlParameter[] parameters = {
                    new SqlParameter("@ivtid", SqlDbType.Int,4),
                    new SqlParameter("@ufts", SqlDbType.Char,10),
                    new SqlParameter("@poid", SqlDbType.Int,4),
                    new SqlParameter("@cchanger", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbustype", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpoid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dpodate", SqlDbType.DateTime),
                    new SqlParameter("@cvencode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersoncode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@carrivalplace", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csccode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@nflat", SqlDbType.Float),
                    new SqlParameter("@itaxrate", SqlDbType.Float),
                    new SqlParameter("@cpaycode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@icost", SqlDbType.Money),
                    new SqlParameter("@ibargain", SqlDbType.Money),
                    new SqlParameter("@cmemo", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cstate", SqlDbType.TinyInt),
                    new SqlParameter("@idiscounttaxtype", SqlDbType.TinyInt),
                    new SqlParameter("@cdefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenabbname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpayname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersonname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cexch_name", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cperiod", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ireturncount", SqlDbType.Int,4),
                    new SqlParameter("@iverifystateex", SqlDbType.Int,4),
                    new SqlParameter("@iswfcontrolled", SqlDbType.Bit,1),
                    new SqlParameter("@cverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccloser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cscname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine4", SqlDbType.DateTime),
                    new SqlParameter("@cdefine5", SqlDbType.Int,4),
                    new SqlParameter("@cdefine6", SqlDbType.DateTime),
                    new SqlParameter("@cdefine7", SqlDbType.Float),
                    new SqlParameter("@cdefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaddress", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpostcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenregcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvoucherstate", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dplanarrdate", SqlDbType.Int,4),
                    new SqlParameter("@cvenbank", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaccount", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenfax", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccontactcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenperson", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cappcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmobilephone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine11", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine12", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine13", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine14", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine15", SqlDbType.Int,4),
                    new SqlParameter("@cdefine16", SqlDbType.Float),
                    new SqlParameter("@cauthid", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine4", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine5", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine6", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine7", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine11", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine12", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine13", SqlDbType.Float),
                    new SqlParameter("@cvendefine14", SqlDbType.Float),
                    new SqlParameter("@cvendefine15", SqlDbType.DateTime),
                    new SqlParameter("@cvendefine16", SqlDbType.DateTime),
                    new SqlParameter("@clocker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaketime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifytime", SqlDbType.DateTime),
                    new SqlParameter("@caudittime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifydate", SqlDbType.DateTime),
                    new SqlParameter("@cauditdate", SqlDbType.DateTime),
                    new SqlParameter("@creviser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocol", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocolname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangaudittime", SqlDbType.DateTime),
                    new SqlParameter("@cchangauditdate", SqlDbType.DateTime),
                    new SqlParameter("@cbg_auditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbg_audittime", SqlDbType.NVarChar,-1),
                    new SqlParameter("@controlresult", SqlDbType.SmallInt),
                    new SqlParameter("@ibg_overflag", SqlDbType.SmallInt),
                    new SqlParameter("@iflowid", SqlDbType.Int,4),
                    new SqlParameter("@cflowname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bflowprocess", SqlDbType.Bit,1),
                    new SqlParameter("@bstorageorder", SqlDbType.Bit,1),
                    new SqlParameter("@iprintcount", SqlDbType.Int,4),
                    new SqlParameter("@dclosedate", SqlDbType.DateTime),
                    new SqlParameter("@dclosetime", SqlDbType.DateTime),
                    new SqlParameter("@csysbarcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccurrentauditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutecode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutename", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bGCTransforming", SqlDbType.Bit,1),
                    new SqlParameter("@yyc_respstatus", SqlDbType.NVarChar,-1),
                    new SqlParameter("@yyc_reason", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssource", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssourceid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhwhadress", SqlDbType.NVarChar,-1)};
            parameters[0].Value = ivtid;
            parameters[1].Value = ufts;
            parameters[2].Value = poid;
            parameters[3].Value = cchanger;
            parameters[4].Value = cbustype;
            parameters[5].Value = cpoid;
            parameters[6].Value = dpodate;
            parameters[7].Value = cvencode;
            parameters[8].Value = cdepcode;
            parameters[9].Value = cpersoncode;
            parameters[10].Value = carrivalplace;
            parameters[11].Value = csccode;
            parameters[12].Value = nflat;
            parameters[13].Value = itaxrate;
            parameters[14].Value = cpaycode;
            parameters[15].Value = icost;
            parameters[16].Value = ibargain;
            parameters[17].Value = cmemo;
            parameters[18].Value = cstate;
            parameters[19].Value = idiscounttaxtype;
            parameters[20].Value = cdefine1;
            parameters[21].Value = cdefine2;
            parameters[22].Value = cdefine3;
            parameters[23].Value = cvenabbname;
            parameters[24].Value = cdepname;
            parameters[25].Value = cpayname;
            parameters[26].Value = cpersonname;
            parameters[27].Value = cexch_name;
            parameters[28].Value = cptcode;
            parameters[29].Value = cperiod;
            parameters[30].Value = cmaker;
            parameters[31].Value = ireturncount;
            parameters[32].Value = iverifystateex;
            parameters[33].Value = iswfcontrolled;
            parameters[34].Value = cverifier;
            parameters[35].Value = cvenname;
            parameters[36].Value = ccloser;
            parameters[37].Value = cptname;
            parameters[38].Value = cscname;
            parameters[39].Value = cdefine4;
            parameters[40].Value = cdefine5;
            parameters[41].Value = cdefine6;
            parameters[42].Value = cdefine7;
            parameters[43].Value = cdefine8;
            parameters[44].Value = cdefine9;
            parameters[45].Value = cvenaddress;
            parameters[46].Value = cvenpostcode;
            parameters[47].Value = cvenregcode;
            parameters[48].Value = cvoucherstate;
            parameters[49].Value = dplanarrdate;
            parameters[50].Value = cvenbank;
            parameters[51].Value = cvenaccount;
            parameters[52].Value = cvenfax;
            parameters[53].Value = ccontactcode;
            parameters[54].Value = cvenperson;
            parameters[55].Value = cappcode;
            parameters[56].Value = cvenphone;
            parameters[57].Value = cmobilephone;
            parameters[58].Value = cdefine10;
            parameters[59].Value = cdefine11;
            parameters[60].Value = cdefine12;
            parameters[61].Value = cdefine13;
            parameters[62].Value = cdefine14;
            parameters[63].Value = cdefine15;
            parameters[64].Value = cdefine16;
            parameters[65].Value = cauthid;
            parameters[66].Value = cvendefine1;
            parameters[67].Value = cvendefine2;
            parameters[68].Value = cvendefine3;
            parameters[69].Value = cvendefine4;
            parameters[70].Value = cvendefine5;
            parameters[71].Value = cvendefine6;
            parameters[72].Value = cvendefine7;
            parameters[73].Value = cvendefine8;
            parameters[74].Value = cvendefine9;
            parameters[75].Value = cvendefine10;
            parameters[76].Value = cvendefine11;
            parameters[77].Value = cvendefine12;
            parameters[78].Value = cvendefine13;
            parameters[79].Value = cvendefine14;
            parameters[80].Value = cvendefine15;
            parameters[81].Value = cvendefine16;
            parameters[82].Value = clocker;
            parameters[83].Value = cmaketime;
            parameters[84].Value = cmodifytime;
            parameters[85].Value = caudittime;
            parameters[86].Value = cmodifydate;
            parameters[87].Value = cauditdate;
            parameters[88].Value = creviser;
            parameters[89].Value = cvenpuomprotocol;
            parameters[90].Value = cvenpuomprotocolname;
            parameters[91].Value = cchangverifier;
            parameters[92].Value = cchangaudittime;
            parameters[93].Value = cchangauditdate;
            parameters[94].Value = cbg_auditor;
            parameters[95].Value = cbg_audittime;
            parameters[96].Value = controlresult;
            parameters[97].Value = ibg_overflag;
            parameters[98].Value = iflowid;
            parameters[99].Value = cflowname;
            parameters[100].Value = bflowprocess;
            parameters[101].Value = bstorageorder;
            parameters[102].Value = iprintcount;
            parameters[103].Value = dclosedate;
            parameters[104].Value = dclosetime;
            parameters[105].Value = csysbarcode;
            parameters[106].Value = ccurrentauditor;
            parameters[107].Value = cgcroutecode;
            parameters[108].Value = cgcroutename;
            parameters[109].Value = bGCTransforming;
            parameters[110].Value = yyc_respstatus;
            parameters[111].Value = yyc_reason;
            parameters[112].Value = csyssource;
            parameters[113].Value = csyssourceid;
            parameters[114].Value = clshwhcode;
            parameters[115].Value = clshwhname;
            parameters[116].Value = clshwhphone;
            parameters[117].Value = clshwhwhadress;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public void GetModel(int ivtid, string ufts, int poid, string cchanger, string cbustype, string cpoid, DateTime dpodate, string cvencode, string cdepcode, string cpersoncode, string carrivalplace, string csccode, decimal nflat, decimal itaxrate, string cpaycode, decimal icost, decimal ibargain, string cmemo, int cstate, int idiscounttaxtype, string cdefine1, string cdefine2, string cdefine3, string cvenabbname, string cdepname, string cpayname, string cpersonname, string cexch_name, string cptcode, string cperiod, string cmaker, int ireturncount, int iverifystateex, bool iswfcontrolled, string cverifier, string cvenname, string ccloser, string cptname, string cscname, DateTime cdefine4, int cdefine5, DateTime cdefine6, decimal cdefine7, string cdefine8, string cdefine9, string cvenaddress, string cvenpostcode, string cvenregcode, string cvoucherstate, int dplanarrdate, string cvenbank, string cvenaccount, string cvenfax, string ccontactcode, string cvenperson, string cappcode, string cvenphone, string cmobilephone, string cdefine10, string cdefine11, string cdefine12, string cdefine13, string cdefine14, int cdefine15, decimal cdefine16, int cauthid, string cvendefine1, string cvendefine2, string cvendefine3, string cvendefine4, string cvendefine5, string cvendefine6, string cvendefine7, string cvendefine8, string cvendefine9, string cvendefine10, int cvendefine11, int cvendefine12, decimal cvendefine13, decimal cvendefine14, DateTime cvendefine15, DateTime cvendefine16, string clocker, DateTime cmaketime, DateTime cmodifytime, DateTime caudittime, DateTime cmodifydate, DateTime cauditdate, string creviser, string cvenpuomprotocol, string cvenpuomprotocolname, string cchangverifier, DateTime cchangaudittime, DateTime cchangauditdate, string cbg_auditor, string cbg_audittime, int controlresult, int ibg_overflag, int iflowid, string cflowname, bool bflowprocess, bool bstorageorder, int iprintcount, DateTime dclosedate, DateTime dclosetime, string csysbarcode, string ccurrentauditor, string cgcroutecode, string cgcroutename, bool bGCTransforming, string yyc_respstatus, string yyc_reason, string csyssource, string csyssourceid, string clshwhcode, string clshwhname, string clshwhphone, string clshwhwhadress)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ivtid,ufts,poid,cchanger,cbustype,cpoid,dpodate,cvencode,cdepcode,cpersoncode,carrivalplace,csccode,nflat,itaxrate,cpaycode,icost,ibargain,cmemo,cstate,idiscounttaxtype,cdefine1,cdefine2,cdefine3,cvenabbname,cdepname,cpayname,cpersonname,cexch_name,cptcode,cperiod,cmaker,ireturncount,iverifystateex,iswfcontrolled,cverifier,cvenname,ccloser,cptname,cscname,cdefine4,cdefine5,cdefine6,cdefine7,cdefine8,cdefine9,cvenaddress,cvenpostcode,cvenregcode,cvoucherstate,dplanarrdate,cvenbank,cvenaccount,cvenfax,ccontactcode,cvenperson,cappcode,cvenphone,cmobilephone,cdefine10,cdefine11,cdefine12,cdefine13,cdefine14,cdefine15,cdefine16,cauthid,cvendefine1,cvendefine2,cvendefine3,cvendefine4,cvendefine5,cvendefine6,cvendefine7,cvendefine8,cvendefine9,cvendefine10,cvendefine11,cvendefine12,cvendefine13,cvendefine14,cvendefine15,cvendefine16,clocker,cmaketime,cmodifytime,caudittime,cmodifydate,cauditdate,creviser,cvenpuomprotocol,cvenpuomprotocolname,cchangverifier,cchangaudittime,cchangauditdate,cbg_auditor,cbg_audittime,controlresult,ibg_overflag,iflowid,cflowname,bflowprocess,bstorageorder,iprintcount,dclosedate,dclosetime,csysbarcode,ccurrentauditor,cgcroutecode,cgcroutename,bGCTransforming,yyc_respstatus,yyc_reason,csyssource,csyssourceid,clshwhcode,clshwhname,clshwhphone,clshwhwhadress ");
            strSql.Append(" FROM [zpurpoheader] ");
            strSql.Append(" where ivtid=@ivtid and ufts=@ufts and poid=@poid and cchanger=@cchanger and cbustype=@cbustype and cpoid=@cpoid and dpodate=@dpodate and cvencode=@cvencode and cdepcode=@cdepcode and cpersoncode=@cpersoncode and carrivalplace=@carrivalplace and csccode=@csccode and nflat=@nflat and itaxrate=@itaxrate and cpaycode=@cpaycode and icost=@icost and ibargain=@ibargain and cmemo=@cmemo and cstate=@cstate and idiscounttaxtype=@idiscounttaxtype and cdefine1=@cdefine1 and cdefine2=@cdefine2 and cdefine3=@cdefine3 and cvenabbname=@cvenabbname and cdepname=@cdepname and cpayname=@cpayname and cpersonname=@cpersonname and cexch_name=@cexch_name and cptcode=@cptcode and cperiod=@cperiod and cmaker=@cmaker and ireturncount=@ireturncount and iverifystateex=@iverifystateex and iswfcontrolled=@iswfcontrolled and cverifier=@cverifier and cvenname=@cvenname and ccloser=@ccloser and cptname=@cptname and cscname=@cscname and cdefine4=@cdefine4 and cdefine5=@cdefine5 and cdefine6=@cdefine6 and cdefine7=@cdefine7 and cdefine8=@cdefine8 and cdefine9=@cdefine9 and cvenaddress=@cvenaddress and cvenpostcode=@cvenpostcode and cvenregcode=@cvenregcode and cvoucherstate=@cvoucherstate and dplanarrdate=@dplanarrdate and cvenbank=@cvenbank and cvenaccount=@cvenaccount and cvenfax=@cvenfax and ccontactcode=@ccontactcode and cvenperson=@cvenperson and cappcode=@cappcode and cvenphone=@cvenphone and cmobilephone=@cmobilephone and cdefine10=@cdefine10 and cdefine11=@cdefine11 and cdefine12=@cdefine12 and cdefine13=@cdefine13 and cdefine14=@cdefine14 and cdefine15=@cdefine15 and cdefine16=@cdefine16 and cauthid=@cauthid and cvendefine1=@cvendefine1 and cvendefine2=@cvendefine2 and cvendefine3=@cvendefine3 and cvendefine4=@cvendefine4 and cvendefine5=@cvendefine5 and cvendefine6=@cvendefine6 and cvendefine7=@cvendefine7 and cvendefine8=@cvendefine8 and cvendefine9=@cvendefine9 and cvendefine10=@cvendefine10 and cvendefine11=@cvendefine11 and cvendefine12=@cvendefine12 and cvendefine13=@cvendefine13 and cvendefine14=@cvendefine14 and cvendefine15=@cvendefine15 and cvendefine16=@cvendefine16 and clocker=@clocker and cmaketime=@cmaketime and cmodifytime=@cmodifytime and caudittime=@caudittime and cmodifydate=@cmodifydate and cauditdate=@cauditdate and creviser=@creviser and cvenpuomprotocol=@cvenpuomprotocol and cvenpuomprotocolname=@cvenpuomprotocolname and cchangverifier=@cchangverifier and cchangaudittime=@cchangaudittime and cchangauditdate=@cchangauditdate and cbg_auditor=@cbg_auditor and cbg_audittime=@cbg_audittime and controlresult=@controlresult and ibg_overflag=@ibg_overflag and iflowid=@iflowid and cflowname=@cflowname and bflowprocess=@bflowprocess and bstorageorder=@bstorageorder and iprintcount=@iprintcount and dclosedate=@dclosedate and dclosetime=@dclosetime and csysbarcode=@csysbarcode and ccurrentauditor=@ccurrentauditor and cgcroutecode=@cgcroutecode and cgcroutename=@cgcroutename and bGCTransforming=@bGCTransforming and yyc_respstatus=@yyc_respstatus and yyc_reason=@yyc_reason and csyssource=@csyssource and csyssourceid=@csyssourceid and clshwhcode=@clshwhcode and clshwhname=@clshwhname and clshwhphone=@clshwhphone and clshwhwhadress=@clshwhwhadress ");
            SqlParameter[] parameters = {
                    new SqlParameter("@ivtid", SqlDbType.Int,4),
                    new SqlParameter("@ufts", SqlDbType.Char,10),
                    new SqlParameter("@poid", SqlDbType.Int,4),
                    new SqlParameter("@cchanger", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbustype", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpoid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dpodate", SqlDbType.DateTime),
                    new SqlParameter("@cvencode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersoncode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@carrivalplace", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csccode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@nflat", SqlDbType.Float),
                    new SqlParameter("@itaxrate", SqlDbType.Float),
                    new SqlParameter("@cpaycode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@icost", SqlDbType.Money),
                    new SqlParameter("@ibargain", SqlDbType.Money),
                    new SqlParameter("@cmemo", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cstate", SqlDbType.TinyInt),
                    new SqlParameter("@idiscounttaxtype", SqlDbType.TinyInt),
                    new SqlParameter("@cdefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenabbname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdepname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpayname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cpersonname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cexch_name", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cperiod", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ireturncount", SqlDbType.Int,4),
                    new SqlParameter("@iverifystateex", SqlDbType.Int,4),
                    new SqlParameter("@iswfcontrolled", SqlDbType.Bit,1),
                    new SqlParameter("@cverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccloser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cptname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cscname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine4", SqlDbType.DateTime),
                    new SqlParameter("@cdefine5", SqlDbType.Int,4),
                    new SqlParameter("@cdefine6", SqlDbType.DateTime),
                    new SqlParameter("@cdefine7", SqlDbType.Float),
                    new SqlParameter("@cdefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaddress", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpostcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenregcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvoucherstate", SqlDbType.NVarChar,-1),
                    new SqlParameter("@dplanarrdate", SqlDbType.Int,4),
                    new SqlParameter("@cvenbank", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenaccount", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenfax", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccontactcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenperson", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cappcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmobilephone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine11", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine12", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine13", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine14", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cdefine15", SqlDbType.Int,4),
                    new SqlParameter("@cdefine16", SqlDbType.Float),
                    new SqlParameter("@cauthid", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine1", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine2", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine3", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine4", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine5", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine6", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine7", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine8", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine9", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine10", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvendefine11", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine12", SqlDbType.Int,4),
                    new SqlParameter("@cvendefine13", SqlDbType.Float),
                    new SqlParameter("@cvendefine14", SqlDbType.Float),
                    new SqlParameter("@cvendefine15", SqlDbType.DateTime),
                    new SqlParameter("@cvendefine16", SqlDbType.DateTime),
                    new SqlParameter("@clocker", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cmaketime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifytime", SqlDbType.DateTime),
                    new SqlParameter("@caudittime", SqlDbType.DateTime),
                    new SqlParameter("@cmodifydate", SqlDbType.DateTime),
                    new SqlParameter("@cauditdate", SqlDbType.DateTime),
                    new SqlParameter("@creviser", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocol", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cvenpuomprotocolname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangverifier", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cchangaudittime", SqlDbType.DateTime),
                    new SqlParameter("@cchangauditdate", SqlDbType.DateTime),
                    new SqlParameter("@cbg_auditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cbg_audittime", SqlDbType.NVarChar,-1),
                    new SqlParameter("@controlresult", SqlDbType.SmallInt),
                    new SqlParameter("@ibg_overflag", SqlDbType.SmallInt),
                    new SqlParameter("@iflowid", SqlDbType.Int,4),
                    new SqlParameter("@cflowname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bflowprocess", SqlDbType.Bit,1),
                    new SqlParameter("@bstorageorder", SqlDbType.Bit,1),
                    new SqlParameter("@iprintcount", SqlDbType.Int,4),
                    new SqlParameter("@dclosedate", SqlDbType.DateTime),
                    new SqlParameter("@dclosetime", SqlDbType.DateTime),
                    new SqlParameter("@csysbarcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@ccurrentauditor", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutecode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@cgcroutename", SqlDbType.NVarChar,-1),
                    new SqlParameter("@bGCTransforming", SqlDbType.Bit,1),
                    new SqlParameter("@yyc_respstatus", SqlDbType.NVarChar,-1),
                    new SqlParameter("@yyc_reason", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssource", SqlDbType.NVarChar,-1),
                    new SqlParameter("@csyssourceid", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhcode", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhname", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhphone", SqlDbType.NVarChar,-1),
                    new SqlParameter("@clshwhwhadress", SqlDbType.NVarChar,-1)};
            parameters[0].Value = ivtid;
            parameters[1].Value = ufts;
            parameters[2].Value = poid;
            parameters[3].Value = cchanger;
            parameters[4].Value = cbustype;
            parameters[5].Value = cpoid;
            parameters[6].Value = dpodate;
            parameters[7].Value = cvencode;
            parameters[8].Value = cdepcode;
            parameters[9].Value = cpersoncode;
            parameters[10].Value = carrivalplace;
            parameters[11].Value = csccode;
            parameters[12].Value = nflat;
            parameters[13].Value = itaxrate;
            parameters[14].Value = cpaycode;
            parameters[15].Value = icost;
            parameters[16].Value = ibargain;
            parameters[17].Value = cmemo;
            parameters[18].Value = cstate;
            parameters[19].Value = idiscounttaxtype;
            parameters[20].Value = cdefine1;
            parameters[21].Value = cdefine2;
            parameters[22].Value = cdefine3;
            parameters[23].Value = cvenabbname;
            parameters[24].Value = cdepname;
            parameters[25].Value = cpayname;
            parameters[26].Value = cpersonname;
            parameters[27].Value = cexch_name;
            parameters[28].Value = cptcode;
            parameters[29].Value = cperiod;
            parameters[30].Value = cmaker;
            parameters[31].Value = ireturncount;
            parameters[32].Value = iverifystateex;
            parameters[33].Value = iswfcontrolled;
            parameters[34].Value = cverifier;
            parameters[35].Value = cvenname;
            parameters[36].Value = ccloser;
            parameters[37].Value = cptname;
            parameters[38].Value = cscname;
            parameters[39].Value = cdefine4;
            parameters[40].Value = cdefine5;
            parameters[41].Value = cdefine6;
            parameters[42].Value = cdefine7;
            parameters[43].Value = cdefine8;
            parameters[44].Value = cdefine9;
            parameters[45].Value = cvenaddress;
            parameters[46].Value = cvenpostcode;
            parameters[47].Value = cvenregcode;
            parameters[48].Value = cvoucherstate;
            parameters[49].Value = dplanarrdate;
            parameters[50].Value = cvenbank;
            parameters[51].Value = cvenaccount;
            parameters[52].Value = cvenfax;
            parameters[53].Value = ccontactcode;
            parameters[54].Value = cvenperson;
            parameters[55].Value = cappcode;
            parameters[56].Value = cvenphone;
            parameters[57].Value = cmobilephone;
            parameters[58].Value = cdefine10;
            parameters[59].Value = cdefine11;
            parameters[60].Value = cdefine12;
            parameters[61].Value = cdefine13;
            parameters[62].Value = cdefine14;
            parameters[63].Value = cdefine15;
            parameters[64].Value = cdefine16;
            parameters[65].Value = cauthid;
            parameters[66].Value = cvendefine1;
            parameters[67].Value = cvendefine2;
            parameters[68].Value = cvendefine3;
            parameters[69].Value = cvendefine4;
            parameters[70].Value = cvendefine5;
            parameters[71].Value = cvendefine6;
            parameters[72].Value = cvendefine7;
            parameters[73].Value = cvendefine8;
            parameters[74].Value = cvendefine9;
            parameters[75].Value = cvendefine10;
            parameters[76].Value = cvendefine11;
            parameters[77].Value = cvendefine12;
            parameters[78].Value = cvendefine13;
            parameters[79].Value = cvendefine14;
            parameters[80].Value = cvendefine15;
            parameters[81].Value = cvendefine16;
            parameters[82].Value = clocker;
            parameters[83].Value = cmaketime;
            parameters[84].Value = cmodifytime;
            parameters[85].Value = caudittime;
            parameters[86].Value = cmodifydate;
            parameters[87].Value = cauditdate;
            parameters[88].Value = creviser;
            parameters[89].Value = cvenpuomprotocol;
            parameters[90].Value = cvenpuomprotocolname;
            parameters[91].Value = cchangverifier;
            parameters[92].Value = cchangaudittime;
            parameters[93].Value = cchangauditdate;
            parameters[94].Value = cbg_auditor;
            parameters[95].Value = cbg_audittime;
            parameters[96].Value = controlresult;
            parameters[97].Value = ibg_overflag;
            parameters[98].Value = iflowid;
            parameters[99].Value = cflowname;
            parameters[100].Value = bflowprocess;
            parameters[101].Value = bstorageorder;
            parameters[102].Value = iprintcount;
            parameters[103].Value = dclosedate;
            parameters[104].Value = dclosetime;
            parameters[105].Value = csysbarcode;
            parameters[106].Value = ccurrentauditor;
            parameters[107].Value = cgcroutecode;
            parameters[108].Value = cgcroutename;
            parameters[109].Value = bGCTransforming;
            parameters[110].Value = yyc_respstatus;
            parameters[111].Value = yyc_reason;
            parameters[112].Value = csyssource;
            parameters[113].Value = csyssourceid;
            parameters[114].Value = clshwhcode;
            parameters[115].Value = clshwhname;
            parameters[116].Value = clshwhphone;
            parameters[117].Value = clshwhwhadress;

            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ivtid"] != null && ds.Tables[0].Rows[0]["ivtid"].ToString() != "")
                {
                    this.ivtid = int.Parse(ds.Tables[0].Rows[0]["ivtid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ufts"] != null)
                {
                    this.ufts = ds.Tables[0].Rows[0]["ufts"].ToString();
                }
                if (ds.Tables[0].Rows[0]["poid"] != null && ds.Tables[0].Rows[0]["poid"].ToString() != "")
                {
                    this.poid = int.Parse(ds.Tables[0].Rows[0]["poid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cchanger"] != null)
                {
                    this.cchanger = ds.Tables[0].Rows[0]["cchanger"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cbustype"] != null)
                {
                    this.cbustype = ds.Tables[0].Rows[0]["cbustype"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpoid"] != null)
                {
                    this.cpoid = ds.Tables[0].Rows[0]["cpoid"].ToString();
                }
                if (ds.Tables[0].Rows[0]["dpodate"] != null && ds.Tables[0].Rows[0]["dpodate"].ToString() != "")
                {
                    this.dpodate = DateTime.Parse(ds.Tables[0].Rows[0]["dpodate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvencode"] != null)
                {
                    this.cvencode = ds.Tables[0].Rows[0]["cvencode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdepcode"] != null)
                {
                    this.cdepcode = ds.Tables[0].Rows[0]["cdepcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpersoncode"] != null)
                {
                    this.cpersoncode = ds.Tables[0].Rows[0]["cpersoncode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["carrivalplace"] != null)
                {
                    this.carrivalplace = ds.Tables[0].Rows[0]["carrivalplace"].ToString();
                }
                if (ds.Tables[0].Rows[0]["csccode"] != null)
                {
                    this.csccode = ds.Tables[0].Rows[0]["csccode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["nflat"] != null && ds.Tables[0].Rows[0]["nflat"].ToString() != "")
                {
                    this.nflat = decimal.Parse(ds.Tables[0].Rows[0]["nflat"].ToString());
                }
                if (ds.Tables[0].Rows[0]["itaxrate"] != null && ds.Tables[0].Rows[0]["itaxrate"].ToString() != "")
                {
                    this.itaxrate = decimal.Parse(ds.Tables[0].Rows[0]["itaxrate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cpaycode"] != null)
                {
                    this.cpaycode = ds.Tables[0].Rows[0]["cpaycode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["icost"] != null && ds.Tables[0].Rows[0]["icost"].ToString() != "")
                {
                    this.icost = decimal.Parse(ds.Tables[0].Rows[0]["icost"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ibargain"] != null && ds.Tables[0].Rows[0]["ibargain"].ToString() != "")
                {
                    this.ibargain = decimal.Parse(ds.Tables[0].Rows[0]["ibargain"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cmemo"] != null)
                {
                    this.cmemo = ds.Tables[0].Rows[0]["cmemo"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cstate"] != null && ds.Tables[0].Rows[0]["cstate"].ToString() != "")
                {
                    this.cstate = int.Parse(ds.Tables[0].Rows[0]["cstate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["idiscounttaxtype"] != null && ds.Tables[0].Rows[0]["idiscounttaxtype"].ToString() != "")
                {
                    this.idiscounttaxtype = int.Parse(ds.Tables[0].Rows[0]["idiscounttaxtype"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine1"] != null)
                {
                    this.cdefine1 = ds.Tables[0].Rows[0]["cdefine1"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine2"] != null)
                {
                    this.cdefine2 = ds.Tables[0].Rows[0]["cdefine2"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine3"] != null)
                {
                    this.cdefine3 = ds.Tables[0].Rows[0]["cdefine3"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenabbname"] != null)
                {
                    this.cvenabbname = ds.Tables[0].Rows[0]["cvenabbname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdepname"] != null)
                {
                    this.cdepname = ds.Tables[0].Rows[0]["cdepname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpayname"] != null)
                {
                    this.cpayname = ds.Tables[0].Rows[0]["cpayname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cpersonname"] != null)
                {
                    this.cpersonname = ds.Tables[0].Rows[0]["cpersonname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cexch_name"] != null)
                {
                    this.cexch_name = ds.Tables[0].Rows[0]["cexch_name"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cptcode"] != null)
                {
                    this.cptcode = ds.Tables[0].Rows[0]["cptcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cperiod"] != null)
                {
                    this.cperiod = ds.Tables[0].Rows[0]["cperiod"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cmaker"] != null)
                {
                    this.cmaker = ds.Tables[0].Rows[0]["cmaker"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ireturncount"] != null && ds.Tables[0].Rows[0]["ireturncount"].ToString() != "")
                {
                    this.ireturncount = int.Parse(ds.Tables[0].Rows[0]["ireturncount"].ToString());
                }
                if (ds.Tables[0].Rows[0]["iverifystateex"] != null && ds.Tables[0].Rows[0]["iverifystateex"].ToString() != "")
                {
                    this.iverifystateex = int.Parse(ds.Tables[0].Rows[0]["iverifystateex"].ToString());
                }
                if (ds.Tables[0].Rows[0]["iswfcontrolled"] != null && ds.Tables[0].Rows[0]["iswfcontrolled"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["iswfcontrolled"].ToString() == "1") || (ds.Tables[0].Rows[0]["iswfcontrolled"].ToString().ToLower() == "true"))
                    {
                        this.iswfcontrolled = true;
                    }
                    else
                    {
                        this.iswfcontrolled = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["cverifier"] != null)
                {
                    this.cverifier = ds.Tables[0].Rows[0]["cverifier"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenname"] != null)
                {
                    this.cvenname = ds.Tables[0].Rows[0]["cvenname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ccloser"] != null)
                {
                    this.ccloser = ds.Tables[0].Rows[0]["ccloser"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cptname"] != null)
                {
                    this.cptname = ds.Tables[0].Rows[0]["cptname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cscname"] != null)
                {
                    this.cscname = ds.Tables[0].Rows[0]["cscname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine4"] != null && ds.Tables[0].Rows[0]["cdefine4"].ToString() != "")
                {
                    this.cdefine4 = DateTime.Parse(ds.Tables[0].Rows[0]["cdefine4"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine5"] != null && ds.Tables[0].Rows[0]["cdefine5"].ToString() != "")
                {
                    this.cdefine5 = int.Parse(ds.Tables[0].Rows[0]["cdefine5"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine6"] != null && ds.Tables[0].Rows[0]["cdefine6"].ToString() != "")
                {
                    this.cdefine6 = DateTime.Parse(ds.Tables[0].Rows[0]["cdefine6"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine7"] != null && ds.Tables[0].Rows[0]["cdefine7"].ToString() != "")
                {
                    this.cdefine7 = decimal.Parse(ds.Tables[0].Rows[0]["cdefine7"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine8"] != null)
                {
                    this.cdefine8 = ds.Tables[0].Rows[0]["cdefine8"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine9"] != null)
                {
                    this.cdefine9 = ds.Tables[0].Rows[0]["cdefine9"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenaddress"] != null)
                {
                    this.cvenaddress = ds.Tables[0].Rows[0]["cvenaddress"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenpostcode"] != null)
                {
                    this.cvenpostcode = ds.Tables[0].Rows[0]["cvenpostcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenregcode"] != null)
                {
                    this.cvenregcode = ds.Tables[0].Rows[0]["cvenregcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvoucherstate"] != null)
                {
                    this.cvoucherstate = ds.Tables[0].Rows[0]["cvoucherstate"].ToString();
                }
                if (ds.Tables[0].Rows[0]["dplanarrdate"] != null && ds.Tables[0].Rows[0]["dplanarrdate"].ToString() != "")
                {
                    this.dplanarrdate = int.Parse(ds.Tables[0].Rows[0]["dplanarrdate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvenbank"] != null)
                {
                    this.cvenbank = ds.Tables[0].Rows[0]["cvenbank"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenaccount"] != null)
                {
                    this.cvenaccount = ds.Tables[0].Rows[0]["cvenaccount"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenfax"] != null)
                {
                    this.cvenfax = ds.Tables[0].Rows[0]["cvenfax"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ccontactcode"] != null)
                {
                    this.ccontactcode = ds.Tables[0].Rows[0]["ccontactcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenperson"] != null)
                {
                    this.cvenperson = ds.Tables[0].Rows[0]["cvenperson"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cappcode"] != null)
                {
                    this.cappcode = ds.Tables[0].Rows[0]["cappcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenphone"] != null)
                {
                    this.cvenphone = ds.Tables[0].Rows[0]["cvenphone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cmobilephone"] != null)
                {
                    this.cmobilephone = ds.Tables[0].Rows[0]["cmobilephone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine10"] != null)
                {
                    this.cdefine10 = ds.Tables[0].Rows[0]["cdefine10"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine11"] != null)
                {
                    this.cdefine11 = ds.Tables[0].Rows[0]["cdefine11"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine12"] != null)
                {
                    this.cdefine12 = ds.Tables[0].Rows[0]["cdefine12"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine13"] != null)
                {
                    this.cdefine13 = ds.Tables[0].Rows[0]["cdefine13"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine14"] != null)
                {
                    this.cdefine14 = ds.Tables[0].Rows[0]["cdefine14"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cdefine15"] != null && ds.Tables[0].Rows[0]["cdefine15"].ToString() != "")
                {
                    this.cdefine15 = int.Parse(ds.Tables[0].Rows[0]["cdefine15"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cdefine16"] != null && ds.Tables[0].Rows[0]["cdefine16"].ToString() != "")
                {
                    this.cdefine16 = decimal.Parse(ds.Tables[0].Rows[0]["cdefine16"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cauthid"] != null && ds.Tables[0].Rows[0]["cauthid"].ToString() != "")
                {
                    this.cauthid = int.Parse(ds.Tables[0].Rows[0]["cauthid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine1"] != null)
                {
                    this.cvendefine1 = ds.Tables[0].Rows[0]["cvendefine1"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine2"] != null)
                {
                    this.cvendefine2 = ds.Tables[0].Rows[0]["cvendefine2"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine3"] != null)
                {
                    this.cvendefine3 = ds.Tables[0].Rows[0]["cvendefine3"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine4"] != null)
                {
                    this.cvendefine4 = ds.Tables[0].Rows[0]["cvendefine4"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine5"] != null)
                {
                    this.cvendefine5 = ds.Tables[0].Rows[0]["cvendefine5"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine6"] != null)
                {
                    this.cvendefine6 = ds.Tables[0].Rows[0]["cvendefine6"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine7"] != null)
                {
                    this.cvendefine7 = ds.Tables[0].Rows[0]["cvendefine7"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine8"] != null)
                {
                    this.cvendefine8 = ds.Tables[0].Rows[0]["cvendefine8"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine9"] != null)
                {
                    this.cvendefine9 = ds.Tables[0].Rows[0]["cvendefine9"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine10"] != null)
                {
                    this.cvendefine10 = ds.Tables[0].Rows[0]["cvendefine10"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvendefine11"] != null && ds.Tables[0].Rows[0]["cvendefine11"].ToString() != "")
                {
                    this.cvendefine11 = int.Parse(ds.Tables[0].Rows[0]["cvendefine11"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine12"] != null && ds.Tables[0].Rows[0]["cvendefine12"].ToString() != "")
                {
                    this.cvendefine12 = int.Parse(ds.Tables[0].Rows[0]["cvendefine12"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine13"] != null && ds.Tables[0].Rows[0]["cvendefine13"].ToString() != "")
                {
                    this.cvendefine13 = decimal.Parse(ds.Tables[0].Rows[0]["cvendefine13"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine14"] != null && ds.Tables[0].Rows[0]["cvendefine14"].ToString() != "")
                {
                    this.cvendefine14 = decimal.Parse(ds.Tables[0].Rows[0]["cvendefine14"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine15"] != null && ds.Tables[0].Rows[0]["cvendefine15"].ToString() != "")
                {
                    this.cvendefine15 = DateTime.Parse(ds.Tables[0].Rows[0]["cvendefine15"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cvendefine16"] != null && ds.Tables[0].Rows[0]["cvendefine16"].ToString() != "")
                {
                    this.cvendefine16 = DateTime.Parse(ds.Tables[0].Rows[0]["cvendefine16"].ToString());
                }
                if (ds.Tables[0].Rows[0]["clocker"] != null)
                {
                    this.clocker = ds.Tables[0].Rows[0]["clocker"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cmaketime"] != null && ds.Tables[0].Rows[0]["cmaketime"].ToString() != "")
                {
                    this.cmaketime = DateTime.Parse(ds.Tables[0].Rows[0]["cmaketime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cmodifytime"] != null && ds.Tables[0].Rows[0]["cmodifytime"].ToString() != "")
                {
                    this.cmodifytime = DateTime.Parse(ds.Tables[0].Rows[0]["cmodifytime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["caudittime"] != null && ds.Tables[0].Rows[0]["caudittime"].ToString() != "")
                {
                    this.caudittime = DateTime.Parse(ds.Tables[0].Rows[0]["caudittime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cmodifydate"] != null && ds.Tables[0].Rows[0]["cmodifydate"].ToString() != "")
                {
                    this.cmodifydate = DateTime.Parse(ds.Tables[0].Rows[0]["cmodifydate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cauditdate"] != null && ds.Tables[0].Rows[0]["cauditdate"].ToString() != "")
                {
                    this.cauditdate = DateTime.Parse(ds.Tables[0].Rows[0]["cauditdate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["creviser"] != null)
                {
                    this.creviser = ds.Tables[0].Rows[0]["creviser"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenpuomprotocol"] != null)
                {
                    this.cvenpuomprotocol = ds.Tables[0].Rows[0]["cvenpuomprotocol"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cvenpuomprotocolname"] != null)
                {
                    this.cvenpuomprotocolname = ds.Tables[0].Rows[0]["cvenpuomprotocolname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cchangverifier"] != null)
                {
                    this.cchangverifier = ds.Tables[0].Rows[0]["cchangverifier"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cchangaudittime"] != null && ds.Tables[0].Rows[0]["cchangaudittime"].ToString() != "")
                {
                    this.cchangaudittime = DateTime.Parse(ds.Tables[0].Rows[0]["cchangaudittime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cchangauditdate"] != null && ds.Tables[0].Rows[0]["cchangauditdate"].ToString() != "")
                {
                    this.cchangauditdate = DateTime.Parse(ds.Tables[0].Rows[0]["cchangauditdate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cbg_auditor"] != null)
                {
                    this.cbg_auditor = ds.Tables[0].Rows[0]["cbg_auditor"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cbg_audittime"] != null)
                {
                    this.cbg_audittime = ds.Tables[0].Rows[0]["cbg_audittime"].ToString();
                }
                if (ds.Tables[0].Rows[0]["controlresult"] != null && ds.Tables[0].Rows[0]["controlresult"].ToString() != "")
                {
                    this.controlresult = int.Parse(ds.Tables[0].Rows[0]["controlresult"].ToString());
                }
                if (ds.Tables[0].Rows[0]["ibg_overflag"] != null && ds.Tables[0].Rows[0]["ibg_overflag"].ToString() != "")
                {
                    this.ibg_overflag = int.Parse(ds.Tables[0].Rows[0]["ibg_overflag"].ToString());
                }
                if (ds.Tables[0].Rows[0]["iflowid"] != null && ds.Tables[0].Rows[0]["iflowid"].ToString() != "")
                {
                    this.iflowid = int.Parse(ds.Tables[0].Rows[0]["iflowid"].ToString());
                }
                if (ds.Tables[0].Rows[0]["cflowname"] != null)
                {
                    this.cflowname = ds.Tables[0].Rows[0]["cflowname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["bflowprocess"] != null && ds.Tables[0].Rows[0]["bflowprocess"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["bflowprocess"].ToString() == "1") || (ds.Tables[0].Rows[0]["bflowprocess"].ToString().ToLower() == "true"))
                    {
                        this.bflowprocess = true;
                    }
                    else
                    {
                        this.bflowprocess = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["bstorageorder"] != null && ds.Tables[0].Rows[0]["bstorageorder"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["bstorageorder"].ToString() == "1") || (ds.Tables[0].Rows[0]["bstorageorder"].ToString().ToLower() == "true"))
                    {
                        this.bstorageorder = true;
                    }
                    else
                    {
                        this.bstorageorder = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["iprintcount"] != null && ds.Tables[0].Rows[0]["iprintcount"].ToString() != "")
                {
                    this.iprintcount = int.Parse(ds.Tables[0].Rows[0]["iprintcount"].ToString());
                }
                if (ds.Tables[0].Rows[0]["dclosedate"] != null && ds.Tables[0].Rows[0]["dclosedate"].ToString() != "")
                {
                    this.dclosedate = DateTime.Parse(ds.Tables[0].Rows[0]["dclosedate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["dclosetime"] != null && ds.Tables[0].Rows[0]["dclosetime"].ToString() != "")
                {
                    this.dclosetime = DateTime.Parse(ds.Tables[0].Rows[0]["dclosetime"].ToString());
                }
                if (ds.Tables[0].Rows[0]["csysbarcode"] != null)
                {
                    this.csysbarcode = ds.Tables[0].Rows[0]["csysbarcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["ccurrentauditor"] != null)
                {
                    this.ccurrentauditor = ds.Tables[0].Rows[0]["ccurrentauditor"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cgcroutecode"] != null)
                {
                    this.cgcroutecode = ds.Tables[0].Rows[0]["cgcroutecode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["cgcroutename"] != null)
                {
                    this.cgcroutename = ds.Tables[0].Rows[0]["cgcroutename"].ToString();
                }
                if (ds.Tables[0].Rows[0]["bGCTransforming"] != null && ds.Tables[0].Rows[0]["bGCTransforming"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["bGCTransforming"].ToString() == "1") || (ds.Tables[0].Rows[0]["bGCTransforming"].ToString().ToLower() == "true"))
                    {
                        this.bGCTransforming = true;
                    }
                    else
                    {
                        this.bGCTransforming = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["yyc_respstatus"] != null)
                {
                    this.yyc_respstatus = ds.Tables[0].Rows[0]["yyc_respstatus"].ToString();
                }
                if (ds.Tables[0].Rows[0]["yyc_reason"] != null)
                {
                    this.yyc_reason = ds.Tables[0].Rows[0]["yyc_reason"].ToString();
                }
                if (ds.Tables[0].Rows[0]["csyssource"] != null)
                {
                    this.csyssource = ds.Tables[0].Rows[0]["csyssource"].ToString();
                }
                if (ds.Tables[0].Rows[0]["csyssourceid"] != null)
                {
                    this.csyssourceid = ds.Tables[0].Rows[0]["csyssourceid"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhcode"] != null)
                {
                    this.clshwhcode = ds.Tables[0].Rows[0]["clshwhcode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhname"] != null)
                {
                    this.clshwhname = ds.Tables[0].Rows[0]["clshwhname"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhphone"] != null)
                {
                    this.clshwhphone = ds.Tables[0].Rows[0]["clshwhphone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["clshwhwhadress"] != null)
                {
                    this.clshwhwhadress = ds.Tables[0].Rows[0]["clshwhwhadress"].ToString();
                }
            }
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [zpurpoheader] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        #endregion  Method
    }
}